Subject How to change Primary Key on a table by adding a new field
Author Luigi Siciliano
Hello,
I have an application that use a Firebird database and I need to
change a Primary Key on a table by adding a new field.

I can drop a primary key constraint by "ALTER TABLE MyTable DROP
CONSTRAINT MyINTEG_000" where "MyINTEG_000" is the constraint on my
development database file.

I cannot use the instruction above because I don't know in all
production databases of my customers the name of the Primary Key I want
update.

How I can solve?

Thanks.
--

Luigi Siciliano
--------------------------