Alter Sequence
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
Resets the next value of an existing sequence.
Syntax
ALTER SEQUENCE sequence_name RESTART WITH value
where:
- sequence_name
- specifies an existing sequence.
- value
- specifies the next value to be returned through the Next Value For clause (see Next Value For Clause).