All Products
Search
Document Center

Lindorm:DROP TABLE

Last Updated:Aug 28, 2023

You can execute the DROP TABLE statement to delete a table.

Usage notes

  • If the LindormTable version of your Lindorm instance is later than 2.2.16 and earlier than 2.4.1, you must execute the OFFLINE TABLE to set the state of a table to offline before you execute the DROP TABLE to delete the table. For more information about the OFFLINE TABLE statement, see OFFLINE TABLE.

  • In LindormTable 2.4.1 and later versions, the OFFLINE TABLE statement is automatically executed before the DROP TABLE is executed.

Syntax

drop_table_statement ::=  DROP TABLE [ IF EXISTS ] table_name

Examples

use my_schema;
DROP TABLE dt;
DROP TABLE IF EXISTS dt;
DROP TABLE my_schema.dt;