Delete Foriegn Keys Records on Cascade

Posted by Self-Innovator under Sql Server category on 3/27/2013 | Points: 40 | Views : 1390

Deleting the foreign key values on Primary key gets deleted

ALTER TABLE Rights
ADD CONSTRAINT fk_RoleId
FOREIGN KEY (RoleId)REFERENCES Roles(Id)
ON DELETE CASCADE

Bookmark It

Latest Code Snipptes