TRUNCATE TABLE statement

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

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;