TRUNCATE TABLE
Description
The TRUNCATE TABLE
statement removes all the rows from a table or partition(s). The table must not be a view
or an external/temporary table. In order to truncate multiple partitions at once, the user can specify the partitions
in partition_spec
. If no partition_spec
is specified it will remove all partitions in the table.
Syntax
Parameters
table_name
- The name of an existing table.
PARTITION ( partition_spec :[ partition_column = partition_col_value, partition_column = partition_col_value, ...] )
- Specifies one or more partition column and value pairs. The partition value is optional.