This topic describes how to use the DROP TABLE statement to delete a specified table.
DROP [TEMPORARY] TABLE [IF EXISTS] tbl_name [, tbl_name] ... [RESTRICT | CASCADE]
- If you execute the DROP TABLE statement to delete a table that contains a global secondary index, the index table and the primary table are both deleted.
- To delete only the index table, execute the ALTER TABLE DROP INDEX statement instead of the DROP TABLE statement. For more information, see ALTER TABLE.
The following example shows how to delete the table named
DROP TABLE user_log;