TRUNCATE TABLE

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

table-Name

The name of the table to truncate.

Examples

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

splice> TRUNCATE TABLE Players_Test;
0 rows inserted/updated/deleted