Friday, October 23, 2009

What is the CASCADE action in SQL Server?

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.

Share This!

No comments:

Powered By Blogger · Designed By Seo Blogger Templates