truncate

TRUNCATE()                       SQL Commands                       TRUNCATE()



NAME
       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 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.



SQL - Language Statements        29 March 2001                      TRUNCATE()