Comments of Table and Columns

• Srinivas-120709

  SSC Veteran

  Points: 273

  More actions

  June 28, 2005 at 12:26 am

  #89631

  Thanks

  fn_listextendedproperty works for comments display.

  I need to see them in EM .

  How to use the special name MS_Description.

  Please advise.

  Again thanks in advance.

   

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  June 28, 2005 at 12:58 am

  #568827

  The answers in the other thread described this I think. Anyway, here is an example that adds a description for a column foo in table bar which can be seen in EM:

  EXECUTE sp_addextendedproperty

  @name='MS_Description'

  , @value = 'The foo of bar'

  , @level0type = N'User'

  , @Level0name = N'dbo'

  , @level1type = N'table'

  , @level1name=N'bar'

  , @level2type = N'column'

  , @level2name = N'foo'

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/