All Products
Search
Document Center

DROP TABLE

Last Updated: Jul 31, 2020

Syntax:

  1. DROP [TEMPORARY] TABLE [IF EXISTS]
  2. tbl_name [, tbl_name] ...
  3. [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
  1. 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.