>>>Hi,
>>>
>>>When creating a FOREIGN KEY constraint in SSMS I get message that:
>>>
>>>…. may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION,
>>>or modify other FOREIGN KEY constraints.
>>>
>>>
>>>If I understand correctly the problem is that the table where I am attempting to set a Foreign key constraint has a dependency on some other table that creates a conflict. My tables have many links. So my question is, how can I find out which table has a link to this table that I need to change? How do I find out?
>>>Thank you for any other suggestions.
>>
>>Can you find a key which is in turn a foreign key in another table? I think this message tells that you have a chained relationship and setting CASCADE option may be problematic.
>
>The table has many foreign keys. I am trying to figure which of the "other" tables where this table has a foreign key "causes" the problem. But I will strart looking into every one of them and see if I can spot what to change.
>Thank you.
BTW, when you were creating this constraint, you created it for the specific key? So, start from that key first.
If it's not broken, fix it until it is.
My Blog