All Products
Search
Document Center

DROP TABLE

Last Updated: Jun 18, 2021

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;