SQL Server Cascading Referential integrity

niwlg2el 于 2023-03-17 发布在其他

关注(0)|答案(1)|浏览(127)

I'm using Employee , City , EmpSalary , EmpOrganization , Salcomponents tables in my database where Employee table CityID column references CityID of City table, and reporting ID column self references EmpID of Employee table

Empsalary table empId references Employee.EmpId
EmpOrganization table empid references Employee.EmpId

I want to design a stored procedure with CityId as input to delete data from Employee , Empsalary , Emporganization simultaneously

Please suggest how to proceed further?

sql-server

来源：https://stackoverflow.com/questions/40818053/cascading-referential-integrity

1条答案

按热度按时间

lkaoscv71#

You don't need a stored proceudre. You can design your foregin key constraints that they cascade the delete:

ALTER TABLE Employee
ADD FOREIGN KEY (CityId) REFERENCES City (Id) ON DELETE CASCADE

This will delete the entry in the City table when the Employee entry is deleted.

赞(0）回复(0）举报 2023-03-17

我来回答

SQL Server Cascading Referential integrity

1条答案

相关问题

热门标签

最新问答