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

Examples

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