SQLServer对列增加备注

EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = 'Postal code is a required column.',
@level0type = N'Schema', @level0name = 'dbo', --指定schema
@level1type = N'Table',  @level1name = 't1', --指定table
@level2type = N'Column', @level2name = 'c1' --指定column