next up previous contents index
Next: UNLISTEN Up: Reference Manual Previous: SHOW

Subsections

TRUNCATE

Name

TRUNCATE -- Empty a table

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.


Bruce Momjian
2001-05-09