Restart Sequence(s)
Go Up to Available object actions by DBMS
This action builds and submits an ALTER SEQUENCE... RESTART/RESTART WITH statement. This lets you reset the current value to either the initial value specified when the sequence was created, or reset it to a specified value.
Platform Availability
To reset the value of a sequence
- Initiate a Restart Sequence(s) action against one or more sequences. 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 | |
---|---|---|
Action options |
Start With |
An integer that will be returned as the next value of the sequence object. The integer must be within the range specified for the sequence. If no value is provided, sequence numbering restarts with the initial value specified when the sequence was created. |
Dependencies |
Lets you review the objects potentially impacted by this action. For more information, see Dependencies. | |
Preview |
Preview the DDL generated for the operation. For more information, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.