Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2012
    Posts
    2

    Unhappy Unanswered: How do I export database properties from visio to word?

    I am trying to generate a report from the database.

    I am using Visio 2010. I would like to include the
    table names, column names , column types and the comments that I
    entered in the NOTES field associated with the tables and columns.
    Basically, I would like to generate a data dictionary report.

    PLEASE HELP ME...

  2. #2
    Join Date
    Nov 2014
    Posts
    1

    Hi, have you ever found a solution for your question ? I'm very interested.

    Quote Originally Posted by Jancooth View Post
    I am trying to generate a report from the database.

    I am using Visio 2010. I would like to include the
    table names, column names , column types and the comments that I
    entered in the NOTES field associated with the tables and columns.
    Basically, I would like to generate a data dictionary report.

    PLEASE HELP ME...
    Hi, have you ever found a solution for your question ? I'm very interested.

  3. #3
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6
    SELECT major_id, minor_id, t.name AS [Table Name], c.name AS [Column Name], value AS [Extended Property] ----Find Column Notes
    FROM sys.extended_properties AS ep
    INNER JOIN sys.tables AS t ON ep.major_id = t.object_id
    INNER JOIN sys.columns AS c ON ep.major_id = c.object_id AND ep.minor_id = c.column_id
    --WHERE class = 1
    ORDER BY [Table Name];
    SELECT [Table_Name] = t.name, [Table_Description] = value
    FROM sys.tables as t
    INNER JOIN sys.extended_properties as sp
    ON sp.major_id = t.object_id
    WHERE minor_id = '0' ------Find Table Notes
    Order By Table_Name

    I used this query to get the extended properties which I believe is what holds in the column notes in SSMS.

Tags for this Thread

Posting Permissions

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