ALTER TABLE...SET INTERVAL v16
Use the ALTER TABLE… SET INTERVAL
command to convert an existing range-partitioned table to an interval range-partitioned table. The database creates a partition of a specified range or interval for the partitioned table when you set INTERVAL
. The syntax is:
To disable an interval range partitioned table and convert it to a range-partitioned table, the syntax is:
Parameters
table_name
The name (optionally schema-qualified) of the range-partitioned table.
constant | expression
Specifies a NUMERIC
, DATE
, or TIME
value.
Description
You can use the ALTER TABLE… SET INTERVAL
command to convert the range-partitioned table to use interval range partitioning. The command creates a new partition of a specified interval. You can then insert data into the new partition.
You can use the SET INTERVAL ()
command to disable interval range partitioning. The database converts an interval range-partitioned table to range partitioned and sets the boundaries of the interval range partitions to the boundaries for the range partitions.
example_setting_an_interval_range_partition
- On this page
- Parameters
- Description