TRUNCATE

TRUNCATE — empty a table

Synopsis

TRUNCATE [ TABLE ] name

Description

TRUNCATE removes all rows from a table. It has the same effect as an unqualified DELETE on the target table. It is just used as a convenience statement.

Parameters

name

The name (optionally schema-qualified) of a table to truncate.

Examples

Truncate the table bigtable:

TRUNCATE bigtable;

See Also

DELETE