• 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)