Re: [firebird-support] Re: Performance problem - input wanted

[michael.vilhelm...@microcom.dk [firebird-support]]

ALTER TABLE VAREFRVSTR_DETAIL ADD CONSTRAINT VAREFRVSTR_DETAIL_VNR 
   FOREIGN KEY (VAREPLU_ID) REFERENCES VARER
   (PLU_NR) 
   ON DELETE NO ACTION
   ON UPDATE CASCADE
 

 

 RDB$FOREIGN105
 ALTER TABLE VAREFRVSTR_DETAIL ADD  
   FOREIGN KEY (AFDELING_ID) REFERENCES AFDELING
   (AFDELINGSNUMMER) 
   ON DELETE NO ACTION
   ON UPDATE NO ACTION