Partition Schemes

Go Up to Supported Objects

Partition schemes map the partitions of a partitioned table or index to filegroups. The number and domain of the partitions for a partitioned table or index are specified in a partition function definition. Partition scheme definitions are referenced when partitioning indexes or tables.

Creating and editing

• Partition Schemes Wizard (SQL Server) and Partition Schemes Editor (SQL Server)

Available Functionality

Object Action	SQL SVR
Drop	✓
Extract	✓
Migrate	✓
Next Used Filegroup	✓
Report	✓

See Also

• Partition Functions
• Partition Functions (SQL Server) - Properties
• Indexes Wizard (SQL Server)
• Tables Wizard (SQL Server)