TRUNCATE TABLE

TRUNCATE TABLE table_name

TRUNCATE TABLE statement is used to clear the specified table.

Example: clear t1

TRUNCATE TABLE t1;
-- Truncate table t1? yes/no
-- yes
-- SUCCEED