How to change the maximum value of a sequence in DB2?

1 year ago

Sophia Anderson

1 minute

You can use the ALTER SEQUENCE statement to change the maximum value of a sequence in DB2. The syntax for modifying the maximum value of a sequence is as follows:

ALTER SEQUENCE sequence_name MAXVALUE new_max_value

sequence_name is the name of the sequence to be modified and new_max_value is the new maximum value.

For example, to change the maximum value of the sequence “my_sequence” to 1000, you can execute the following statement:

ALTER SEQUENCE my_sequence MAXVALUE 1000

Please note that changing the maximum value of the sequence may impact the data in the existing table. Before modifying the maximum value of the sequence, make sure you have carefully considered the potential consequences.