ALTER TABLE [dbo] . [CHEQUES] WITH CHECK ADD FOREIGN KEY ([NUMERO_FACTURA]) REFERENCES [dbo] . [FACTURAS] ([NUMERO_FACTURA]) ON UPDATE CASCADE ON DELETE CASCADE GO ME DA ESTE ERROR EN EL PRIMER PROGAMA DE PORGRAMASION: Msg 1785, Level 16, State 0, Line 1 Introducing FOREIGN KEY constraint FK__CHEQUES__NUMERO___239E4DCF on table CHEQUES may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Msg 1750, Level 16, State 0, Line 1 Could not create constraint. See previous errors.
Posted on: Mon, 17 Mar 2014 13:59:35 +0000