TRUNCATE TABLE statement

TRUNCATE TABLE statement The TRUNCATE TABLE statement quickly removes all content from the specified table and returns it to its initial empty state. TRUNCATE TABLE statementSQL statementsTRUNCATE TABLEtablesspace

To truncate a table, you must be either the database owner or the table owner.

You cannot truncate system tables or global temporary tables with this statement.

Syntax TRUNCATE TABLE tableName Examples

To truncate the entire Flights table, use the following statement: TRUNCATE TABLE Flights;