Subject Re: [firebird-support] Moving primary key to another column
Author Tomasz Tyrakowski
On 2012-08-05 19:26, Matthias Hanft wrote:
> Now I don't want to be NBR the primary key any more (the numbers there
> have a special meaning where I need to have some "0" entries now); I'd
> like to insert another "ID" colum which should be the new primary key
> (and filling it automatically from 1 to N by a generator).


That's the procedure I've been using in the past in such cases:

1. drop the current primary key (alter table MyTable drop constraint
2. create the generator (create generator MyGen)
3. create the new primary key column (alter table MyTable add NewKey not
4. fill the new column using the generator:
update MyTable set NewKey=(select gen_id(MyGen,1) from RDB$DATABASE)
5. create the primary key anew (alter table MyTable add constraint
NewPrimaryKeyName primary key(NewKey) )

No extra table required.


__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== ==--__