Subject | Re: [firebird-support] Primary Key Initial Value |
---|---|
Author | André Knappstein |
Post date | 2013-06-18T14:00:52Z |
> In creating a new table, how is primary key set to begin at a value other than 0 or 1?"begin" suggests that you plan on some form of auto-incrementing a
value for the primary key field?
If so, I'd say you'll need a generator anyway.
You can set this generator to any (valid) value you like, but you
should always be aware that especially setting it to a lower value
than before can mean a lot of trouble.
Here's the syntax for Firebird 2.5
ALTER SEQUENCE <Generator_Name> RESTART WITH <new_Value>