Subject Re: [ib-support] Changing the primary key
Author Roberto de Amorim
Thanks!

> Try
>
> ALTER TABLE <tablename> DROP CONSTRAINT <pkconstraintname>;
>
> If you don't know the name of your primary key constraint
> you can obtain it by
>
> SELECT RDB$CONSTRAINT_NAME FROM RDB$RELATION_CONSTRAINTS
> WHERE RDB$RELATION_NAME='<tablename>' AND
> RDB$CONSTRAINT_TYPE='PRIMARY KEY';
>