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:

Databases and Data Visualisations Course for kids Week 1

As mentioned last week, I have started the Databases and Data Visualisations course for kids aged between 11 to 15 years yesterday. It was...