Drop a table

When you no longer need a table, you can use the DROP TABLE statement to drop it.

MySQL mode

You can execute either of the following statements to drop a table:

obclient> DROP TABLE test;

or

obclient> DROP TABLE IF EXISTS test;

If you specify IF EXISTS when you drop a table, no error is reported even if the table to be deleted does not exist. Otherwise, an error is reported.

Oracle mode

You can execute either of the following statements to drop a table:

obclient> DROP TABLE test;

Operating instructions

For the DROP TABLE operation:

• If recycle bin is disabled in the tenant, the DROP TABLE operation deletes the table. You can set the recyclebin parameter to enable or disable recycle bin. By default, recycle bin is disabled.

• If recycle bin is enabled, the table dropped by the DROP TABLE operation is moved to the recycle bin. Tables in the recycle bin can be permanently deleted or recovered. For more information about the recycle bin, see Recycle bin for databases, tables, and indexes.