TRUNCATE TABLE¶

Remove all content from a table and return it to its initial, empty state. TRUNCATE TABLE clears all in-memory data for the specified table as well as any data that was persisted to SnappyData disk stores.

TRUNCATE TABLE table-name

Description¶

To truncate a table, you must be the table's owner. You cannot use this command to truncate system tables.

Example¶

To truncate the "flights" table in the current schema:

TRUNCATE TABLE flights;

Related Topics

• CREATE TABLE

• DROP TABLE

• DELETE TABLE

• SHOW TABLES