ALTER DOMAIN INTERBASE ON PRIMARY KEY

[Robert Gilland 5]

I am using the have an Interbase database with an Interbase2020 server.

I have a table with a field of TYPE CHAR(6) DOMAIN CALLED INVOICECODE in it's primary key

I call ALTER DOMAIN INVOICECODE TYPE CHAR(10)

I get "unsuccessful metadata update MODIFY RDB$FIELDS failed action cancelled by trigger (1) to preserve data integrity RDB$TRIGGER_39 Cannot update index segment used by an Integrity Constraint"

 

What can I do?

[tgbs 16]

Drop Primary key, alter domain, recreate primary key. If You have Foreign keys - first drop them