Column Descriptions in a table. How do we retrieve them using SQL

• mw_sql_developer

  SSCoach

  Points: 19445

  More actions

  January 22, 2015 at 1:14 pm

  #314054

  The following adds a description to the column in a view. Good! I am assuming the same can be done to a table. ? Agree ?

  Question: Using SQL how do we see a tables column names and description using a SELECT statement

  EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cocenpt Description from Identifier for MPOG Procedure Room' , @level0type=N'SCHEMA',@level0name=N'Derived', @level1type=N'VIEW',@level1name=N'Case_General', @level2type=N'COLUMN',@level2name=N'MPOG_Procedure_Room_Type_Desc'

  GO

• ScottPletcher

  SSC Guru

  Points: 101192

  More actions

  January 22, 2015 at 3:56 pm

  #1772432

  You can use either:

  function "fn_listextendedproperty"

  or directly read view "sys.extended_properties"

  SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".