truncate table Syntax

The trucate table command removes all rows from a table.

The syntax for truncate table is:
truncate table [ [ database.]owner.]table_name 
	[ partition partition_name ]

For example, to remove all the data in sales, type:

truncate table sales 

Permission to use truncate table, like drop table, defaults to the table owner and cannot be transferred.

A truncate table command is not caught by a delete trigger.

Related concepts
Partition Tables and Indexes
Triggers: Enforce Referential Integrity