Set the description programmatically

To set the description programmatically, you can use the sp_addextendedproperty,sp_updateextendedproperty and sp_dropextendedproperty stored procedures. Example:

 

EXEC sp_addextendedproperty
@name = N’MS_Description’, @value = ‘I=Image, P=PDF, V=Video, H=HTML, E=Email, N=None’,
@level0type = N’Schema’, @level0name = ‘dbo’,
@level1type = N’Table’, @level1name = ‘DocCategoryMaster’,
@level2type = N’Column’, @level2name = ‘DocCategoryType’;