Click here to Skip to main content
15,892,072 members
Search within:


Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths. Specify on DELETE NO ACTION or on UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
.NET-Core
 
error occurred while creating database by code first


What I have tried:

error occurred while creating database by code first
Posted
Updated 6-Jun-18 1:50am
Add a Solution
Comments
Patrice T 6-Jun-18 2:01am    
Do you have a question ?

1 solution

You have to do what it says. You are trying to create a foreign key that will possibly cascade into a loop or into multiple paths and SQL does not like it.
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Introducing FOREIGN KEY constraint! ! !
Introducing FOREIGN KEY constraint 'FK_dbo.Votes_dbo.Nodes_NodesId' on table 'Votes' may cause cycles or multiple cascade paths
on delete cascade constraint
multiple on delete cascade of foreign key in one table
Failed to add the foreign key constraint. Missing index for constraint ' in the referenced table ''
Sql: how do I add a constraint foreign key
Alter table FOREIGN KEY error
mysql foreign key constraint error
Foreign Key constraint on Delete
Foreign key constraint to multiple fields

Advertise
Privacy
Cookies
Terms of Use
Last Updated 6 Jun 2018
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900