When you first open the page you see a listing of the databases on the server.
Clicking a database expands it to show its schemas.
Expanding a schema shows its tables along with their Creation Date, Size, Number
of Rows and Description. You can sort by these attributes or by the table names
by clicking the headings.
Expanding a table shows its data columns along with their Position, Null Permission,
Data Type and Description. You can sort these attributes or the column names by
clicking the headings.
Add or edit a description to any table or column.
Descriptions you view, add or edit are the same ones that are used by SQL Server
Management Studio or SQL Server Enterprise Manager.
Clicking the "Details" button for a table leads to a print friendly page that
displays columns, indexes, constraints and foreign keys.
NEW! You can now define your own categories of properties!
This means that in addition to "MS_Description" you can add "Version", "Data Source"
or anything else you can think of and then View, Add or Edit text for them.
Quick & easy install - that's why it's called "Instant Data Dictionary"
- Download and run installer on your web server.
- Provide your username, password and order number.
- Provide a connection string to your database.
- Specify which databases you don't want to include.
- That's it! No setup on the database is required.
Click here to be notified when other database servers are supported.