Help Center > > Developer Guide

DROP TABLE

Updated at: Jul 14, 2021 GMT+08:00

Function

The TSDB extension engine provides DDL statements for deleting time series tables. These DDL statements can delete created time series tables, partition creation policies, and partition eviction policies.

Syntax

DROP TABLE [ IF EXISTS ]
{ [schema.]table_name } [, ...] [ CASCADE | RESTRICT ];

Parameter Description

  • IF EXISTS

    Reports a notice instead of an error if the specified table does not exist.

  • schema

    Specifies the schema name.

  • table_name

    Specifies the name of the table to be deleted.

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes the objects (such as views) that depend on the table.
    • RESTRICT: refuses to delete the table if any objects depend on it. This is the default action.

Examples

1
2
-- Delete a simple time series table.
DROP TABLE CPU;

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel