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 tableName

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

TRUNCATE TABLE Flights;