vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Prabhat Dalmia (prabhatdalmia@hotmail.com) writes: > I have a huge databasea and I need to be able to enable cascade delete > on a lot of tables. If I do it manually - it will be very time > consuming. I am looking for a flag in the system tables where I can > enable this. Any answers are highly appreciated. There is no such flag. But you can set up foreign-key constraints that have the option ON CASCADE DELETE. Note, though, that SQL Server disallow cascading if it thinks there is risk for circular dependencies, and it is fairly conservative and disallows maybe more than it should. -- Erland Sommarskog, SQL Server MVP, sommar@algonet.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp |