DROP TABLE
Function
DROP TABLE deletes a specified table.
Precautions
- DROP TABLE forcibly deletes a specified table. After a table is deleted, any indexes that exist for the table will be deleted; any functions or stored procedures that use this table cannot be run. Deleting a partitioned table also deletes all partitions in the table.
- Only the table owner, schema owner, or a user granted with the DROP permission can run DROP TABLE on a table. A system administrator has this permission by default. To delete all the rows in a table but retain the table definition, use TRUNCATE or DELETE.

- Be cautious when using DROP OBJECT (e.g., DATABASE, USER/ROLE, SCHEMA, TABLE, VIEW) as it may cause data loss, especially with CASCADE deletions. Always back up data before proceeding.
- For more information about development and design specifications, see Development and Design Proposal.
Syntax
1 2 |
DROP TABLE [ IF EXISTS ] { [schema.]table_name } [, ...] [ CASCADE | RESTRICT ] ; |
Parameter Description
Parameter |
Description |
Value Range |
---|---|---|
IF EXISTS |
Reports a notice instead of an error if the specified table does not exist. |
- |
schema |
Name of the schema to which the table to be deleted belongs. |
- |
table_name |
Specifies the name of the table to be deleted. |
An existing table name. |
CASCADE | RESTRICT |
Specifies how to process related data in the dependent object when a delete operation is performed. |
|
PURGE |
If the Purge parameter is specified, data is directly deleted regardless of whether the recycle bin feature is enabled. This is supported only by clusters of version 9.1.0.200 or later. |
- |
KEEP ttl HOUR |
In V3 tables, enabling the recycle bin feature and setting a TTL allows physical files to be moved to the recycle bin for potential restoration. However, once the TTL expires, the background process automatically clears the objects in the recycle bin. This is supported only by clusters of version 9.1.0.200 or later.
NOTICE:
You are advised to use this parameter in scenarios where the drop and truncate operations are not frequently performed. |
- |
Examples
Delete the warehouse_t1 table:
1
|
DROP TABLE tpcds.warehouse_t1; |
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot