You can use the TRUNCATE TABLE statement to clear data from a specified table. In LindormTable V2.2.16 or later, execute the OFFLINE TABLE statement, and then execute the TRUNCATE TABLE statement to prevent table data from being cleared by accidental operations.

Syntax

truncate_table_statement ::= TRUNCATE TABLE table_name
Note table_name specifies the name of the destination table.

Examples

TRUNCATE TABLE dt;
TRUNCATE TABLE my_schema.dt;