I have Database DB and Table CB ..CB has 3 dependent Tables OB ,CP,CI
So My Requirement is ..
delete From CB
where ID_NUM not Like '99%'
But here delete will not work because of FK .. so i need to delete records from OB CP CI Tables first ...and I need to store all the Deleted Records of all the 4 Tables (CB,OB,CP,CI) in a seperate Table
May be all 4 deleted values in a Table
each table deleted records in each Seperate newly created table..
all i Know to go each child table and delete but ....It may be time Running Script ...
Individuall for Each delete and Store in new table
Can any one Help me on This .....
View Complete Post