TRUNCATE TABLE

Removes all storage associated with a table, while leaving the table definition intact.

Removes all storage associated with a table, while leaving the table definition intact. TRUNCATE TABLE auto-commits the current transaction after statement execution and cannot be rolled back.

TRUNCATE TABLE also performs the following actions:

  • Removes all table history preceding the current epoch. After TRUNCATE TABLE returns, AT EPOCH queries on the truncated table return nothing.

  • Drops all table- and partition-level statistics.

Syntax

TRUNCATE TABLE [[database.]schema.]table-name

Parameters

[database.]schema

Database and schema. The default schema is public. If you specify a database, it must be the current database.

table-name
The name of the anchor table or temporary table to truncate. You cannot truncate an external table.

Privileges

Non-superuser:

  • Table owner

  • USAGE privileges on table schema

Examples

See Truncating tables.

See also