“Instant” Data Dictionary

Tuesday 14 October 2014 @ 11:21 am

I have a previous post that shows simple ways to report on the structure of a database.   This month one of my readers sent me a report that gives you more detail, if you are using a SQL Server database. You point the report to your DB connection, the report reads all the tables and fields and prints out a schema of the tables and views. The schema includes the table name, field names, date type & length, primary key, foreign key, if the field allows nulls, and a description (if there are descriptions in the meta data). Just do a Set Datasource Location on it to your server/database and let it run. Note that if you have hundreds of tables this might take a while.

If you have access to the server you can get this same information directly from the Enterprise Manger, but not everyone has been granted this kind of access.  Once run, you have all the tools in CR to find specific items, or you can export to .pdf and search the PDF.

You can download the RPT file here.  The saved data is an example taken from a Goldmine contact manager database.

Or you can read this post to get the SQL needed to generate your own report









Leave a Reply

Jeff-Net
Recrystallize Pro

Crystal Reports Server