kstefan
Say Hey Kid
Points: 667
More actions
March 22, 2002 at 12:59 pm
#78421
Is there a way to find the correct order to delete data from some tables, when relationships exist between them and without removing the relationships?
Antares686
SSC Guru
Points: 125444
March 22, 2002 at 1:19 pm
#425947
Check out Use DELETE On Many Tables With Foreign Keys here at http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=220, I have not tried but it is supposed to so the job.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 22, 2002 at 1:41 pm
#425948
It works allright
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply