ALTER PARTITION SCHEME

Change the allocation of a NEXT USED filegroup to a partition scheme.

Syntax
      ALTER PARTITION SCHEME partition_scheme
         NEXT USED [filegroup] [;]

Key
   file_group     A single filegroup to be designated as NEXT USED. Must already exist.

The filegroup does not need to be empty, one file group may be used for multiple partitions.

To remove the NEXT USED allocation, run the command without specifying any filegroup.

Example

ALTER PARTITION SCHEME myRangePtnScheme
NEXT USED fg4;

"The difference between a politician and a statesman is: a politician thinks of the next election and a statesman thinks of the next generation" - Freeman Clarke

Related commands:

ALTER PARTITION FUNCTION
CREATE PARTITION FUNCTION
CREATE PARTITION SCHEME
DROP PARTITION SCHEME

Equivalent Oracle command:

ALTER TABLE Partitioning clause