One day I got an assignment to figure out, how some SQL-based system works. I was shocked by the number of tables, fields inside tables, their properties. I simply imagined myself walking through VB code, finding out some SQL-related code, going back to SQL Server management tools to check what is there and back.
Plus, I found that there are identical field names inside different tables.
So, it didn't take me long to calculate how many time I am about to loose searching through the tables, their properties and values.
So, I decided to invent another toy for myself (just to have some pleasure of working with someone VB and ASP code).
Here is this toolkit - didn't find proper name and named it as SQL Properties Toolkit.
This is simple SQL explorer, but it gives you overview of the all fields/tables inside SQL database.
This toy saved me lot of time (even considering time to write it - what actually took about 2-3 hours) and could save lot of time for you as well. Sure, it was written by the use of classes and objects from the VP Studio - this saves lot of time as well.
If you are interested in sources of this application - send email.
To download - click here
Copyright 1998-2002 EDMGROUP (Australia)
Last Updated: April 4, 2002