Drop a table

If a table is no longer needed, you can use the DROP TABLE statement to drop it.

Here is an example:

obclient> DROP TABLE test;

or

obclient> DROP TABLE IF EXISTS test;

When deleting a table, if IF EXISTS is specified, no error will be reported even if the table to be dropped does not exist; if IF EXISTS is not specified, an error will be reported.

Note

For the DROP TABLE statement:

• If the recycle bin is disabled within a tenant, a DROP TABLE operation directly drops the specified table.

• If the recycle bin is enabled within a tenant, a DROP TABLE operation moves the specified table to the recycle bin. For tables in the recycle bin, you can choose to drop or restore them later. For more information about the recycle bin, see Recycle bin for databases, tables, and indexes.

• You can set the system variable recyclebin to control the recycle bin, which is disabled by default.