| Subject | Drop a field with PK with FB 2.1 |
|---|---|
| Author | Guido Klapperich |
| Post date | 2008-04-08T09:23:47Z |
Yesterday I found it by accident, that with FB 2.1 it is possible to
drop a field, that is a part of a PK constraint. With FB 2.0.3 I get an
error
ALTER TABLE CUSTOMERGROUPS DROP CUID
Error:
ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
column CUID from table CUSTOMERGROUPS is referenced in index
PK_CUSTOMERGROUPS
Is this by design, that this is possible with FB 2.1?
Regards
Guido
drop a field, that is a part of a PK constraint. With FB 2.0.3 I get an
error
ALTER TABLE CUSTOMERGROUPS DROP CUID
Error:
ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
column CUID from table CUSTOMERGROUPS is referenced in index
PK_CUSTOMERGROUPS
Is this by design, that this is possible with FB 2.1?
Regards
Guido