2 foreign key to the same table may cause cycles or multiple cascade paths

Viewed 1597

Merry Christmas,

I'm looking to find a alternative database design to avoid this ULTRA SAFE error:

Introducing FOREIGN KEY constraint '%1' on table '%2' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.

When 2 fields of the same table refer to the same FK. Eg:

People: {Id, Name, Age, Gender}

FamilyRelative: {PersonId, FamiliarId, Relationship}
            FK: FamilyRelative.PersonId ->People.Id ON DELETE CASCADE ON UPDATE CASCADE
            FK: FamilyRelative.FamiliarId->People.Id ON DELETE CASCADE ON UPDATE CASCADE

Throws an error on the second FK.

PS: I'm testing it in SQL Server 2008R2

2 Answers
Related