You can execute the DROP TABLE statement to delete a specified table.
DROP TABLE [IF EXISTS] tbl_name;
Note If you execute the DROP TABLE statement to delete a table from a PolarDB-X instance, the corresponding physical tables are automatically deleted.
If tables that have a global secondary index are deleted, the corresponding base tables and the corresponding index tables are deleted.
Do not execute this statement to delete only an index table. To delete an index, execute the
ALTER TABLE DROP INDEXstatement.
DROP TABLEstatement can delete only one table in each execution. If you attempt to delete multiple tables at a time by executing the DROP TABLE statement, an error message is returned.
You can execute the following statement to delete a table named
DROP TABLE user_log;