Delete Foriegn Keys Records on Cascade

Self-Innovator
Posted by Self-Innovator under Sql Server category on | Points: 40 | Views : 808
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

Comments or Responses

Login to post response