SQL Server error code
SQL Server error 1785
SQL Server raises error 1785 at severity 16, which marks a problem with the query or data that you can correct.
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.
| Msg | 1785 |
|---|---|
| Name | CRTFKINVTOPO |
| Severity | 16 |
| Group | 1000–1999 |
What it means
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 DELETE or an UPDATE statement. The tree of cascading referential actions must only have one path to a particular table on the cascading referential actions tree.