Drop a table

If you no longer need a table, 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;

You can use IF EXISTS to avoid error reports. If the table to be dropped does not exist, no error is returned if you specify IF EXISTS in the statement.

For the DROP TABLE statement, note that:

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

• If the recycle bin is enabled, a DROP TABLE operation moves the specified table to the recycle bin. Tables in the recycle bin can be permanently deleted or restored. For more information about the recycle bin, see Restore objects from the recycle bin.

• You can set the recyclebin parameter to enable or disable the recycle bin. By default, the recycle bin is disabled.