I have three tables in sql. They are connected to each other via foreign keys. If I want to delete the record associated in all 3 tables how do I do this. When I simply deleting a record, I got this error:
Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the REFERENCE constraint "FK_tblOrgObjectives_tblOrgGoals". The conflict occurred in database "CAPRegistration", table "dbo.tblOrgObjectives", column 'GoalID'.
The statement has been terminated.