TRUNCATE TABLE statement

The TRUNCATE TABLE statement allows you to quickly remove all content from the specified table and return it to its initial empty state.

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

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

Syntax

TRUNCATE TABLE table-Name

To truncate the entire Flights table, use the following statement:

TRUNCATE TABLE Flights;