Cascading Delete for every relationship in a database
Posted on 2005-04-28
I have a database that I need to clean about half of the records out of because a client is selling off half of his company. The whole thing is a huge mess of tables with various dependencies all over the place. I need to know if anyone knows of a script that can be run or an option that can be set to automatically allow cascading delete for every relationship in the entire database. Thanks! I'd make this worth more points, but I'm new and that's all I've got.