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).
Matthias, 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 OldPrimaryKeyName) 2. create the generator (create generator MyGen) 3. create the new primary key column (alter table MyTable add NewKey not null) 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. regards Tomasz -- __--==============================--__ __--== Tomasz Tyrakowski ==--__ __--== SOL-SYSTEM ==--__ __--== http://www.sol-system.pl ==--__ __--==============================--__ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
