Subject Re: [firebird-support] Moving primary key to another column
Author Thomas Steinmaurer
>> Is this possible within the "live" database/table, or do I have to create
>> a new table with the colums needed, and do some "INSERT INTO NEWTABLE
>> SELECT FROM OLDTABLE" and finally rename the new table to the old name?
> Well, since it was somewhat urgent, I did it by creating a new table,
> but as renaming a table seems to be something you cannot do without
> manipulating the system tables, I created a third table with the
> name of the original table and copied the "temp" table into it.
> Just the question remains: Is it possible to "move" the primary key
> within an existing table? (I remember I had to do this already a
> couple of times in the past few years.)

Only by dropping and re-adding.

With regards,
Thomas Steinmaurer