On 8-2-2019 11:24, Jiří Činčura wrote:
Hi,
is there a way to change the intial value of generator/sequence *without*
restarting it?
Based on its name, I would guess this is the task for 'START WITH'
clause in:
CREATE OR ALTER SEQUENCE <sequence name> START WITH <value>
Unfortunately it behaves as
ALTER SEQUENCE <sequence name> RESTART WITH <value>
So it doesn't seem that there is any option.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel