About table dropping

This topic describes how to drop a table in OceanBase Database in Oracle mode.

Prerequisites

The current user has the DROP privilege for the target table.

Syntax

DROP TABLE table_name [CASCADE CONSTRAINTS] [PURGE];

Parameters

Examples

1. View the structure of the dws_ny table.

   obclient>SELECT t.table_name tablename FROM user_tables t;
   +-----------+
   | TABLENAME |
   +-----------+
   | CUST      |
   | WARE      |
   | T1        |
   | DWS_NY    |
   +-----------+
   4 rows in set
   

2. Drop the dws_ny table.

   obclient> DROP TABLE dws_ny;
   Query OK, 0 rows affected
   

3. View the results.

   obclient> SELECT t.table_name tablename FROM user_tables t;
   +-----------+
   | TABLENAME |
   +-----------+
   | CUST      |
   | WARE      |
   | T1        |
   +-----------+
   3 rows in set