April 30, 2009 at 1:09 pm
I am looking out for a tool through which we can summarise all the columns(name,datatype,description) in the tables that we have in our database,in this way a new person can easily understand the database structure of a firm.I am presently using SQL Server 2008 as DB.I would really appreciate your help.
May 1, 2009 at 7:03 am
What format do you want it in? Do you want to include relationships (Foreign Keys)?
You can query most of the data yourself using T-SQL using the INFORMATION_SCHEMA views. You could also purchase a product that does it one of which is RedGate SQL Doc.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 1, 2009 at 11:47 am
you can bring in a Database Diagram as well.
Unless you've populated a description of the field in the extended properties, I'm not sure a tool helps.
If you want something beyond a database diagram, I'd look at Er/Studio (Embarcadero) or ErWin to help you reverse/forward engineer things. That makes it really easy to see what tables and fields are there along with relationships.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply