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;

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. The recycle bin is controlled by the recyclebin system variable. By default, it is disabled.

• If the recycle bin is enabled, a DROP TABLE operation moves the specified table to the recycle bin. For tables in the recycle bin, you can permanently delete or restore them later. For more information about the recycle bin, see Restore objects from the recycle bin.