Next Used Filegroup
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
- Initiate a Next Used Filegroup action against a partition scheme. For more information, see Initiating an object operation.
- 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 |
Preview the DDL generated for the operation. For more information, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.