Next Used Filegroup
Go Up to [[Available object actions by DBMS{{#if:||{{{2}}}}}]]
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.
