Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Cascade Delete

By catalin1976,

Having two tables Parent and Derived in ont-to-many relations we want to realize a cascade delete so that for a certain list of parent to delete all the coresponding items from Derived I use a INSTEAD OF DELETE.

Total article views: 860 | Views in the last 30 days: 1
 
Related Articles
FORUM

Deleting Table

Deleting

FORUM

delete table

delete

FORUM

Delete

Delete Query

FORUM

Delete

Performance of Delete

FORUM

Deletion

Deletion of records

Tags
miscellaneous    
 
Contribute