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.

Use SQL Server Management Studio to execute the SQL script (all .sql files) to create the necessary tables and relationships, and insert data.

SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals.

In November, Microsoft released version 18.4 for the SQL Server Management Studio (SSMS), introducing some key features such as support for materialized view scripts in SQL Data Warehouse.