TRUNCATE
SQL - Language Statements
TRUNCATE
Close a cursor
1999-07-20
TRUNCATE TABLE table
1998-09-08
Inputs
table
The table name to truncate.
1998-09-08
Outputs
TRUNCATE
Message returned if the table is successfully truncated.
1998-09-08
Description
TRUNCATE quickly removes all rows from a table.
Usage
Truncate the table bigtable.
TRUNCATE TABLE bigtable;
Compatibility
1998-09-08
SQL92
There is no TRUNCATE in SQL92.