By default, you can not delete a record or update the referenced column in a referenced table if that record is referenced from the dependent table. If you want to be able to delete or update such records, then you need to set up a CASCADE action for the delete and/or update.
What is the CASCADE action in SQL Server?
Posted by
Rajesh Rolen
at
Friday, October 23, 2009
Labels: SQL , SQL Interview Questions , sqlserver
1 comments:
http://markonzo.edu gwankak impediments http://blog.tellurideskiresort.com/members/Ashley-Furniture.aspx http://community.goldenfoot.com/profile/adtsecurity http://bbs.chinafoods.cn/User/4608/Profile.aspx loudon http://www.rottentomatoes.com/vine/showthread.php?p=17358489 http://www.qxpress.com/cs/members/Keno.aspx trains
Post a Comment