Next Used Filegroup

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action builds and submits an ALTER PARTITION SCHEME... NEXT USED statement, letting you alter the designated NEXT USED filegroup for a partition scheme.

Platform Availability

To Change a Partition Scheme’s Next Used Filegroup

  1. Initiate a Next Used Filegroup action against a partition scheme. For more information, see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the dialog:
Step Settings and tasks

Next Used Filegroup

Select the new filegroup from the Filegroup Name dropdown.


Preview the DDL generated for the operation. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.