Clear data in a table-Lindorm(Lindorm)-阿里云帮助中心

Removes all rows from a table while preserving its schema and indexes.

Applicable engines

LindormTable

TRUNCATE TABLE table_identifier

SQL engine 2.6.10 or later: Run TRUNCATE TABLE directly.
SQL engine earlier than 2.6.10: Set the table to OFFLINE status using OFFLINE TABLE before running TRUNCATE TABLE.

TRUNCATE TABLE removes all row data but does not delete the table schema or indexes.

The following examples clear all data from the sensor table.

SQL engine 2.6.10 or later

TRUNCATE TABLE sensor;

SQL engine earlier than 2.6.10

-- Set the table to OFFLINE first.
OFFLINE TABLE sensor;

-- Clear all data from the table.
TRUNCATE TABLE sensor;