SQL Reference Guide > SQL Reference Guide > SQL Statements > ALTER SEQUENCE > ALTER SEQUENCE Examples
Was this helpful?
ALTER SEQUENCE Examples
Change sequence settings that were specified when the sequence was created:
1. Change the start value so that sequence “XYZ” starts at sequence item 10.
ALTER SEQUENCE XYZ RESTART WITH 10
2. Change the increment value of sequence “XYZ” to 20.
ALTER SEQUENCE XYZ INCREMENT BY 20
Last modified date: 08/29/2024