How to check column comments in sql server

• vibhu22oct

  Old Hand

  Points: 392

  More actions

  September 17, 2012 at 10:58 am

  #266762

  Hi,

  Please tell me how can I check column comments or description of column in SQL Server.

  Regards

  Vibhu

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  September 17, 2012 at 11:04 am

  #1538731

  vibhu22oct (9/17/2012)

  ---

  Hi,

  Please tell me how can I check column comments or description of column in SQL Server.

  Regards

  Vibhu

  A little vague as I am not quite sure what you are asking here.

• kl25

  Hall of Fame

  Points: 3752

  More actions

  September 17, 2012 at 11:13 am

  #1538738

  Right click the table or column and select properties. Look in the extended properties.

  If the database has a diagram, check the description field in the properties of the table or column.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 17, 2012 at 3:41 pm

  #1538836

  You can also query that data from the "ms_description" extended property.

  See fn_listextendedproperty

  -- Gianluca Sartori

• kl25

  Hall of Fame

  Points: 3752

  More actions

  September 17, 2012 at 3:42 pm

  #1538837

  Thanks! Didn't know about that function.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 17, 2012 at 3:50 pm

  #1538839

  kl25 (9/17/2012)

  ---

  Thanks! Didn't know about that function.

  Another option is querying sys.extended_properties directly.

  -- Gianluca Sartori

• kl25

  Hall of Fame

  Points: 3752

  More actions

  September 17, 2012 at 4:14 pm

  #1538846

  Thanks again. Should have figured there was a catalog view but didn't know about it either. Based on the view suggested, the OP may find the following helpful:

  Select

  schema_name(so.schema_id) as 'schema',

  so.name as 'table',

  Coalesce(sc.name, '--') as 'column',

  sep.value as 'description'

  From

  sys.extended_properties sep

  Inner join

  sys.objects so

  On

  sep.major_id = so.object_id

  Left outer join

  sys.columns sc

  On

  so.object_id = sc.object_id and

  sep.minor_id = sc.column_id

  Where

  sep.name = 'MS_Description' and

  so.type = 'U';