Implementing Partitioned Tables and Indexes
SQL Server 2008
The topics in this section provide the information to help you create, modify, and view partitioned tables and indexes.
Topic | Description |
|---|---|
Explains how to create partition functions and partition schemes, and how to apply them to a table or index. | |
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. |
