SQL Server Database Explorer

Category:
Database
Type:
Applications
Difficulty:
Advanced
Author:
Srdjan

Version Compatibility: Visual Basic 6

More information:
This is basically an implementation of Enterprise manager in Visual Basic, though it does not contain the entire feature set. However, it allows you to connect to a specified SQL Server and database and view all tables and columns in a treeview, and all the data in a grid control. It also displays objects such as stored procedures, views, foreign keys, etc. You can also use the application to run queries and administer the database.

Important Notes (by FreeVBCode.com):

  1. This is an ambitious application and it did not work perfectly in our tests. For instance, it attempts to display all the data in each selected table, and this will cause time-out errors on large databases. It is best used as a learning tool, for servers with small databases, or as a starting point for a more robust implementation.
  2. You need to set your screen resolution to 1024 X 768 to view all elements of the application

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 sqldbexplorer.zip