Altering Partition Scheme in SQL SERVER
§ The partition scheme is altered to add new filegroup which may be required when partitions are splitted . § The Syntax is as follows ALTER PARTITION SCHEME NEXT USED < Filegroup Name > § The below example shows how it associates a new filegroup FG4 to the partition scheme. ALTER PARTITION SCHEME EmployeePartitionScheme NEXT USED EmployeePartitionFG3