10.3.13 ALTER TABLE… TRUNCATE PARTITION

Table of Contents Previous Next



Use the ALTER TABLETRUNCATE PARTITION command to remove the data from the specified partition, leaving the partition structure intact. The syntax is:
ALTER TABLE table_name TRUNCATE PARTITION partition_name
[{DROP|REUSE} STORAGE]
Use the ALTER TABLETRUNCATE PARTITION command to remove the data from the specified partition, leaving the partition structure intact. When you truncate a partition, any subpartitions of that partition are also truncated.
ALTER TABLETRUNCATE PARTITION will not cause ON DELETE triggers that might exist for the table to fire, but it will fire ON TRUNCATE triggers. If an ON TRUNCATE trigger is defined for the partition, all BEFORE TRUNCATE triggers are fired before any truncation happens, and all AFTER TRUNCATE triggers are fired after the last truncation occurs.
You must have the TRUNCATE privilege on a table to invoke ALTER TABLETRUNCATE PARTITION.
DROP STORAGE and REUSE STORAGE are included for compatibility only; the clauses are parsed and ignored.
The example that follows removes the data from a partition of the sales table. Use the following command to create the sales table:
Populate the sales table with the command:
Querying the sales table shows that the partitions are populated with data:
To delete the contents of the americas partition, invoke the following command:
Now, querying the sales table shows that the content of the americas partition has been removed:


Table of Contents Previous Next