Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to use on delete cascade in SQL Server 2005 RE: How to use on delete cascade in SQL Server 2005
Pravin Patel-491467
Say Hey Kid
Points: 674
More actions
April 29, 2009 at 5:25 am
#985796
For use delete cascade use following Create table script...
CREATE TABLE test_child
(SUB1 INT,
[NO] int,
FOREIGN KEY ([NO]) REFERENCES Test_parent
ON DELETE CASCADE)