Products
High-quality database products to meet full lifecycle enterprise data management needs.
Resources
Various types of resources about OceanBase and the database industry
Docs
Rich content to meet the content demands of using products and solving product usage problems
OceanBase Database
Download PDF
OceanBase, A Highly Scalable Database for Transactional, Analytical, and AI Workloads.
Resources
© OceanBase 2024. All rights reserved | Cloud Service Agreement | Privacy Policy | Legal | Security
OceanBase DatabaseYou can use this statement to drop tables from OceanBase Database.
DROP TABLE table_name [CASCADE CONSTRAINTS] [PURGE];
| Parameter | Description |
|---|---|
| table_name | The name of the table to be dropped. |
| CASCADE CONSTRAINTS | Drops the constraints correlated with the table specified by table_name. |
| PURGE | Purges the table (without moving it to the recycle bin). |
Drop the tbl1 table.
obclient> DROP TABLE tbl1;
Query OK, 0 rows affected