1785

Product

Name

Event ID

1785

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

CRTFKINVTOPO

Message

Text

Introducing FOREIGN KEY constraint ‘%.ls’ on table ‘%.ls’ may cause cycles or multiple

cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify

other FOREIGN KEY constraints.

You receive this error message because in SQL Server, a table cannot appear more than one

time in a list of all the cascading referential actions that are started by either a

or an

statement. The tree of cascading referential actions must only have one path to a

particular table on the cascading referential actions tree.

An error message like the following is reported to the user:

Server: Msg 1785, Level 16, State 1, Line 1 Introducing FOREIGN KEY constraint ‘fk_two’ on

table ‘table2’ may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION

or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Server: Msg 1750,

Level 16, State 1, Line 1 Could not create constraint. See previous errors

ﾉ

Expand table

DELETE
UPDATE