Delete a table - AnalyticDB - Alibaba Cloud Documentation Center

You can execute the DROP TABLE statement to delete a table.

Syntax

DROP TABLE db_name.table_name [FORCE];

Note

When you execute the DROP TABLE statement to delete a table, both the data and schema of the table are deleted.
When you execute the DROP TABLE statement to delete a table for an AnalyticDB for MySQL cluster of V3.2.3.0 or later, the table is automatically moved to the table recycle bin and is permanently deleted after three days. For more information, see Table recycle bin.
Tables deleted by using the DROP TABLE ... FORCE statement are permanently deleted and cannot be recovered.

Delete the adb_demo.customer table.
```
DROP TABLE adb_demo.customer;          
```
Permanently delete the adb_demo.customer table.
```
DROP TABLE adb_demo.customer FORCE;
```