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:

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...