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.
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
ALTER PARTITION FUNCTION
CREATE PARTITION FUNCTION
CREATE PARTITION SCHEME
DROP PARTITION SCHEME
Equivalent Oracle command:
ALTER TABLE Partitioning clause