数据库:SQL SERVER2008
新增字段SQL
--PositionInfo表增加Requirement字段。
IF EXISTS (
SELECT 1 FROM SYSOBJECTS T1
INNER JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID
WHERE T1.NAME='PositionInfo' AND T2.NAME='Requirement'
)
begin
PRINT '存在'
end
else
begin
begin tran
alter table PositionInfo
add Requirement ntext
--添加字段说明
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'岗位要求' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PositionInfo', @level2type=N'COLUMN',@level2name=N'Requirement'
commit tran
end