Hi, what is ondelete cascade in Sql Server, where it is useful? Can anybody give me an example?
ON DELETE CASCADE is a clause that determines the action to be taken when a user tries to delete a key to which an existing foreign key points to.
Specifically, if an attempt is made to delete a row with a key referenced by foreign keys in existing rows in other tables, all rows that contain those foreign keys are also deleted.
Here is the MSDN page that describes (with examples) the various cascading referential integrity constraints.
No one has followed this question yet.