Export (0) Print
Expand All

Implementing Partitioned Tables and Indexes

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

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.

Community Additions

ADD
Show:
© 2014 Microsoft