TRUNCATE -- empty a table
TRUNCATE [ TABLE ] name
The name (optionally schema-qualified) of the table to be truncated.
- TRUNCATE TABLE
Message returned if the table is successfully truncated.
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 useful on large tables.
TRUNCATE cannot be executed inside a transaction
block (BEGIN/COMMIT pair), because there is
no way to roll it back.
Truncate the table bigtable:
TRUNCATE TABLE bigtable;
There is no TRUNCATE in SQL92.
This file was copied from PostgreSQL 7.3.1 help system.