CREATE PARTITION SCHEME

Create a partition scheme in the current database - map the partitions of a partitioned table or index to filegroups.

Syntax
      CREATE PARTITION SCHEME partition_scheme
         AS PARTITION partition_function
            [ALL] TO ( { file_group | [PRIMARY]} [ ,...n ] )
               [; ]

Key
   partition_function  The function using the partition scheme. Must already exist.
   ALL                 All partitions will map to this (one) file group.
   file_group          Names of the filegroup(s) to hold the partitions. Must already exist.

In the example below the last file group (fg3) is not actually needed, so it will be marked as the 'next used' filegroup in the partition scheme.

Example

CREATE PARTITION FUNCTION myPtnFunct (int)
AS RANGE LEFT FOR VALUES (1, 50, 500);
GO
CREATE PARTITION SCHEME myRangePtnScheme
AS PARTITION myPtnFunct
TO ( fg1, fg1, fg1, fg2, fg3 );

"Most of the things we do have never been done before" - Enron corporate, 'who we are' statement

Related commands:

CREATE PARTITION FUNCTION
ALTER PARTITION SCHEME
DROP PARTITION SCHEME
Equivalent Oracle command: ALTER TABLE Partitioning clause