Post reply

Table Structure (Data Dictionary) as HTML

  • August 13, 2008 at 11:55 am

    #72786

    Some time back I had a little utility that documented my table structure, fields, lengths (basically sp_help) in HTML linked fashion. I can't find it. Is there something built into Enterprise Manager that does this? Does someone know how else I can do this?

    Thanks

    ST

  • August 13, 2008 at 12:13 pm

    #857630

    there's something in script contributions that you can grab; i've updated my version slightly so that it also documents FUNCTIONS, which was not part of the original submission.

    you can grab a copy here if it helps:

    db_documentation_in_html_script_enhanced.sqll

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 13, 2008 at 12:46 pm

    #857653

    There are some third party products to do this, and I think we have some scripts here as well.

  • August 13, 2008 at 12:51 pm

    #857657

    Thanks, just what the doc ordered.

    ST

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply