修改数据库结构时，添加注释

USE WMS 
GO
--异常标识 【0 为正常 10为异常】
ALTER TABLE dbo.Package ADD [Status] int NULL;
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常标识 【0 为正常 10为异常】' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Package', @level2type=N'COLUMN',@level2name=N'Status';

--异常原因
ALTER TABLE dbo.Package ADD [AbnormalReasons] VARCHAR(256) NULL;
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'异常原因' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Package', @level2type=N'COLUMN',@level2name=N'AbnormalReasons';
GO