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


© Copyright SS64.com 1999-2014
Some rights reserved