Implementing Partitioned Tables and Indexes

Implementing Partitioned Tables and Indexes


Creating Partitioned Tables and Indexes
Explains how to create partition functions and partition schemes, and how to apply them to a table or index.
Modifying Partitioned Tables and Indexes
Explains how to modify partition functions and partition schemes, how to convert a nonpartitioned table to a partitioned table and vice versa, and how to move partitions between tables.
Querying Data and Metadata from Partitioned Tables and Indexes
Explains how to query data from a partitioned table, how to use the $PARTITION scheme to obtain information about individual partitions, and how to obtain metadata about partitioned tables through the catalog views.