Use of CASCADE CONSTRAINTS in SQL

Hi Sharad,

Cascade Constraints, are usually used when there exists a parent-child relationship between tables using foreign key or referential constraints defined.

For Example, In case of deletion a record from the Parent Table, where there exists a foreign key to the child table,

If you do not specify cascading deletes, the default behavior of the database prevents us from deleting data in the Parent table if the child table has a reference to the Parent.

http://msdn.microsoft.com/en-us/library/aa933119%28v=sql.80%29.aspx

http://msdn.microsoft.com/en-us/library/ms186973%28v=sql.105%29.aspx

By using cascading referential integrity constraints, you can define the actions that the SQL Server takes when a user tries to delete or update a key to which existing foreign keys point.