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
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