|Linux & Unix Commands - Search Man Pages
TRUNCATE(7) SQL Commands TRUNCATE(7)
TRUNCATE - empty a table
TRUNCATE [ TABLE ] name
name The name (optionally schema-qualified) of the table to be truncated.
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
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.
SQL - Language Statements 2002-11-22 TRUNCATE(7)
All times are GMT -4. The time now is 11:07 AM.