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