How to give Descriptions for the Columns in the table?

• murugappan.kathiresan

  Valued Member

  Points: 54

  More actions

  April 12, 2010 at 6:13 am

  #139744

  Hi,

  Is there any way to give the Descriptions for the columns while creating the SQL table?

  Thanks in Advance

• kavali.ongole

  Old Hand

  Points: 320

  More actions

  April 12, 2010 at 7:07 am

  #1150013

  if exists (select * from ::fn_listextendedproperty('MS_Description', 'schema', 'dbo', 'table', 'EMPLOYEE', 'column', 'EMP_NUM'))

  BEGIN

  exec sys.sp_dropextendedproperty 'MS_Description', 'schema', 'dbo', 'table', 'EMPLOYEE', 'column', 'EMP_NUM'

  END

  exec sys.sp_addextendedproperty 'MS_Description', 'DESCRIPTION OF THE COLUMN.', 'schema', 'dbo', 'table', 'EMPLOYEE', 'column', 'EMP_NUM'

  go