This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
Name
TRUNCATE -- Empty a table
Synopsis
TRUNCATE [ TABLE ] name
Inputs
- name
-
The name of the table to be truncated.
Outputs
- TRUNCATE
-
Message returned if the table is successfully
truncated.
Description
TRUNCATE quickly removes all rows from
a table. It has the same effect as an unqualified DELETE but since it does not actually scan the
table it is faster. This is most effective on large tables.
Usage
Truncate the table bigtable:
TRUNCATE TABLE bigtable;
Compatibility
SQL92
There is no TRUNCATE in SQL92.