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
0 comments:
Post a Comment