DB2 Sequence Reset: Modify Current Value

1 year ago
Ava Mitchell
1 minute

To modify the current value of a sequence in DB2, you can use the following SQL statement:

ALTER SEQUENCE sequence_name RESTART WITH new_value;

In this case, sequence_name is the name of the sequence to be modified, and new_value is the new current value to be set. With the above SQL statement, the current value of the sequence can be set to the specified value.

bannerAds