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;

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.