The syntax of 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
For information about the partition clause, see Chapter 10, “Partitioning Tables and Indexes.”
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. See Chapter 20, “Triggers: Enforcing Referential Integrity.”
