There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, doing so may not be as easy as it seems.

Microsoft says it's hard at work on a Visual Studio edition product targeted specifically at database developers and that it plans to ship it by year's end.

A new database-oriented tool in Visual Studio Team System will let programmers more easily make, test changes to database designs.

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.