TRUNCATE TABLE

Remove all content from a table and return it to its initial, empty state.

Syntax

TRUNCATE TABLE table-name

Description

To truncate a table, you must be the table's owner. You cannot use this command to truncate system tables.

Example

To truncate the "flights" table in the current schema:

TRUNCATE TABLE flights;