Implementing Partitioned Tables and Indexes

The topics in this section provide the information to help you create, modify, and view partitioned tables and indexes.

In This Section

Topic

Description

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.