DocsICP FilingConsole
官方文档
首页

DROP TABLE

更新时间：
复制 MD 格式
我的收藏

You can execute the DROP TABLE command to delete 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：TRUNCATE TABLENext：Table recycle bin