Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    Singapore
    Posts
    71

    Unanswered: How To Display The Column Description in Query Analyser

    Hello All.

    I have created a table with short name as the file name but have entered the description in the column box (when creating a new table - see attached). I would like to show this description information in query analyser. Can this be done? I used sp_help <table name> but it doesn't show the description.

    Please advise. Thank you.


    Best regards
    Attached Thumbnails Attached Thumbnails Column_Desc.bmp  

  2. #2
    Join Date
    Jun 2002
    Location
    Singapore
    Posts
    71
    Sorry, typo error on 1st line. It should be column name and not file name.

  3. #3
    Join Date
    Jun 2004
    Posts
    8

    Retreiving Extened Properties

    Quote Originally Posted by limteckboon
    Hello All.

    I have created a table with short name as the file name but have entered the description in the column box (when creating a new table - see attached). I would like to show this description information in query analyser. Can this be done? I used sp_help <table name> but it doesn't show the description.

    Please advise. Thank you.


    Best regards
    you can use the fn_listextendedproperty function to get extended properties.

    For Example,
    SELECT *
    FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'TableName', 'column', default)

    will give you extented properties for each column in the give table name. if you replace default with the specific comun name it will return only that coulmn's properties.

    Good Luck,

    Chad

Posting Permissions

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