Connect with Peer Bloggers

Get your Bloggers ID and network with best bloggers around the world.

13

Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints

Czetsuya
czetsuya's tech ― Have you encountered this error:"Introducing FOREIGN KEY constraint 'x_y_Target' on table 'z_UsersInRoles' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints."It appears when you have violated cascading referential constraints. A good example is the ff relationship:aspnet_Applications->aspnet_Users->aspnet_UsersInRolesaspnet_Applications->aspnet_Roles->aspnet_UsersInRolesAs you can see if you delete a[...]

Voted by 1 User



What would you say?

Be the first to comment on this blog post! Sign in or Create an account.