TRUNCATE TABLE

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