新增字段

USE hisdb
GO
IF NOT EXISTS(SELECT * FROM syscolumns WHERE id = OBJECT_ID('YB_Match') AND name = 'CenterWBCode')
BEGIN
ALTER TABLE YB_Match
ADD CenterWBCode VARCHAR(50) NULL
EXEC sp_bindefault 'DEFAULT_ZERO', 'YB_Match.CenterWBCode'
EXEC sp_addextendedproperty N'MS_Description', N'五笔码', 'SCHEMA', N'dbo', 'TABLE', N'YB_Match', 'COLUMN', N'CenterWBCode'
END