Subject Re: [firebird-support] Re: Error creating Foreign key
Author Dimitry Sibiryakov
13.06.2018 8:47, Mourad Hedfi mourad@... [firebird-support] wrote:
> "You must use "wait" transaction for metadata changes. " ==> What command I must add for
> that ?

https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-transacs-statements.html

> ALTER TABLE FINSMR_INDIC_SMR_ATR ADD CONSTRAINT FK3_FINSMR_INDIC_SMR_ATR FOREIGN KEY (FINSMR_ATR_CODE_FK_PK) REFERENCES ATR_AVISCOMMISSIONTRANSPARENCE (ATR_CODE_SQ_PK) ON DELETE CASCADE - This operation is not defined for system tables.

"ATR_AVISCOMMISSIONTRANSPARENCE" is too long name. Make it short.

--
WBR, SD.