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 TIBCO ComputeDB disk stores.
TRUNCATE TABLE table-name
To truncate a table, you must be the table's owner. You cannot use this command to truncate system tables.
To truncate the "flights" table in the current schema:
TRUNCATE TABLE flights;