DROP [TEMPORARY] TABLE [IF EXISTS]
tbl_name [, tbl_name] ...
[RESTRICT | CASCADE]
Deleting a table in Distributed Relational Database Service (DRDS) is the same as that in MySQL. The system automatically processes deletion operations related to physical tables. For the detailed syntax, see MySQL DROP TABLE Statement.
- Delete the user_log table
DROP TABLE user_log;
Note: When you delete a table that contains a global secondary index (GSI), the index table and the primary table are also deleted. Index tables cannot be deleted alone. To delete an index, execute the
ALTER TABLE DROP INDEX statement.