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 trun
cated.
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 effec
tive on large tables.
USAGE
Truncate the table bigtable:
TRUNCATE TABLE bigtable;
COMPATIBILITY
SQL92
There is no TRUNCATE in SQL92.
Man(1) output converted with
man2html