Subject Re: [firebird-support] Moving primary key to another column
Author Milan Babuskov
Matthias Hanft wrote:
>> 4. fill the new column using the generator:
>> update MyTable set NewKey=(select gen_id(MyGen,1) from RDB$DATABASE)

update MyTable set NewKey = gen_id(MyGen,1);

> Brilliant :-) (I already wondered how to fill up an "incrementing"
> column automagically.)

Well, now you know of 2 ways to do it ;)

Milan Babuskov

The easiest way to import XML, CSV
and textual files into Firebird: