Implementing Partitioned Tables and Indexes

Community Content

In this section

Statistics Annotations (1)

Other versions are also available for the following:

SQL Server 2008 Books Online (June 2009)

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.