Description
This statement deletes tables from an ApsaraDB for OceanBase database.
Syntax
DROP TABLE table_name [CASCADE CONSTRAINTS] [PURGE]
Parameter description
| Parameter | Description |
|---|---|
| table_name | The name of the table to be deleted. |
| CASCADE CONSTRAINTS | Performs a cascade delete for the constraints that are associated with table_name. |
| PURGE | Purges the table. The table is not recycled in the recycle bin. |
Examples
- Delete the test table.
DROP TABLE test;