Results 1 to 11 of 11
  1. #1
    Join Date
    Nov 2004
    Posts
    51

    Unanswered: Documentation of the Tables in SQL Server

    Hi all
    I have 15 tables in my database and I want to create a pdf file with description about all the columns of these tables(Data Model)
    Few questions
    How can I get all the column names in the excel or pdf file?
    Is there any tool which can give me the output template for these columns and then I just have to fill the description for each column?
    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You can query the Information _Schema tables to get a listing of tables and their columns.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you ask your dba?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by Brett Kaiser
    Did you ask your dba?
    Better yet ... did you buy your dba lunch?

    -- This is all just a Figment of my Imagination --

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My preference would be to create a script that will create the tables (complete with constraints, etc) and then comment that script liberally. You can use Visual Studio, SQL Enterprise Mangler, or SQL-DMO to make the script if you don't already have one.

    Once you've done this, check the fully commented script into source code control too!

    -PatP

  6. #6
    Join Date
    Nov 2004
    Posts
    51
    Thanks guys for the responses
    Here I am talking about an already built system and I am trying to document the database

  7. #7
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    You can look on Red Gate i think they have a tool for that

  8. #8
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    Quote Originally Posted by hillcat
    You can look on Red Gate i think they have a tool for that
    so do I, and it's better than redgate's. see the link in my sig.

  9. #9
    Join Date
    Nov 2004
    Posts
    51
    Thanks
    I wish there was any free/open source solution!

  10. #10
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Pat's solution (post #5) is free. I have a binder on my desk that's full of well commented "script" files of all my table definitions. Columns, indexes, triggers, etc. Every time I change a table, I regenerate the script and put new comments in. The extra 5 minutes is worth the effort.
    Inspiration Through Fermentation

  11. #11
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    I don't consider a pile of commented source files as documentation. Would the the source code to SQL Server (heavily commented) tell you how to use it? Not really.

    There are some free ones out there (but you get what you pay for). for example:

    http://www.codeplex.com/datadictionary

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •