DocsICP FilingConsole
Documentation
Home Page AnalyticDB AnalyticDB for MySQL Developer Reference SQL Manual DDL statements DROP TABLE DROP TABLE syntax

DROP TABLE syntax

Updated at:
Copy as MD
My Favorites

The DROP TABLE command deletes a table along with its data and schema.

Syntax

DROP TABLE db_name.table_name [FORCE];
Note

  • This command deletes both the table data and the table schema.

  • For clusters that run Milvus version 3.2.3.0 or later, tables deleted using the DROP TABLE command are automatically moved to the recycle bin. By default, they are permanently deleted after three days. For more information, see Recycle bin.

  • Tables deleted using the DROP TABLE ... FORCE command are permanently deleted and cannot be recovered.

Examples

  • Delete the adb_demo.customer table.

    DROP TABLE adb_demo.customer;

  • Permanently delete the adb_demo.customer table.

    DROP TABLE adb_demo.customer FORCE;
Previous：DROP TABLENext：Table recycle bin