Subject | Re: [ib-support] Changing the primary key |
---|---|
Author | Roberto de Amorim |
Post date | 2002-01-04T16:06:18Z |
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';
>