问题描述
我有一个主表，该表的主键列由同一数据库中其他表中的许多列所引用，我想删除该表中的行而不必先删除其他表(具有对该表的引用值) .我可以在Access中简单地做到这一点，但在SQL Server中似乎有点棘手.
您能指导我如何实现这一目标吗?我喜欢简单性，我感觉到Access中有这种感觉，那时候我认为这就是为什么它们提供了所谓的外键"！
非常感谢！
I have a master table with a primary key column refered to by many columns in other tables in the same database, I want to delete a row in that table without having to delete others first (which have referent values to that table). I can simply do this in Access but it seems a bit tricky in SQL Server.
Could you please guide me through the how to achieve that? I like the simplicity, I felt how it is in Access and at that time I thought that''s why they provide the so-called "foreign key"!
Thank you very much!
推荐答案
ALTER TABLE MasterTable
ADD CONSTRAINT fk_xyz
FOREIGN KEY (xyz)
REFERENCES ChildTable (xyz) ON DELETE CASCADE
这篇关于如何删除具有列作为SQL Server中其他表的外键的表中的行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！