Creating and maintaining partitioned tables involves using a mix of the following types of commands:
Commands to partition and unpartition the table
Commands to drop and re-create clustered indexes to maintain data distribution on the partitions and/or on the underlying physical devices
Parallel bulk copy commands to load data into specific partitions
Commands to display information about data distribution on partitions and devices
Commands to update partition statistics
This section presents the syntax and examples for the commands you use to create and maintain partitioned tables.
For different scenarios that require different combinations of these commands, see “Steps for partitioning tables”.
Use the alter table command to partition and unpartition a table.