The article looks at automating Microsoft SQL server from visual basic using SQL Distributed Management Objects
(SQLDMO object library). In this part, I'll explain about connecting to Sqlserver, getting a list of all the available databases, tables and fields.
In this part, I'll look at altering an existing Table by adding a new column and populating the existing rows in the table with a default value. I also look at adding a Computed Column to the table using SQLDMO.