Examine a Database Schema in VB 2005

Category:
C#, VB.NET, ASP.NET
Type:
Applications
Difficulty:
Intermediate
Author:
Scott Lysle

Version Compatibility: Visual Basic.NET

More information:
The documentation included in this project describes an easy approach to examining all of the tables, views, and columns in a database. The article style documentation is written to describe an example application that may be used to connect to a database (Oracle, SQL Server, or MS Access), view that database’s tables and views, and drill down into each table or view to generate a list of all of its contained columns. Further, the application will allow the user to examine the definition associated with each column (e.g. its data type, caption, default value, etc.).

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download db_spy_package.zip