Saturday, September 05, 2009

Delete all data from a database

I had a requirement today to delete all data from a sqlser ver database. This database has about 350 tables with a lot constraints. I manually started identifying the order of deletion absed on the constraints and realsied that this can't be done in a day. So I hit the good old google for help.

Here I found a very detailed explanation of how to easily achieve this by Susan Sales Harkins. Read More

No comments:

OneLake: The Heart of Your Data Universe in Microsoft Fabric

Imagine a single, unified data lake for your entire organization, accessible to every workload, without data duplication. That's the pow...