【原】SQL判断表字段是否存在，并添加字段

便于使用，特记于此：

 

USE IFP
GO
IF NOT EXISTS(SELECT * FROM syscolumns WHERE [ID] = object_id(N'tempTableRatedElements') AND [NAME] = N'ID')
ALTER TABLE dbo.tempTableRatedElements ADD [ID] INT IDENTITY(1,1) CONSTRAINT [PK_tempTableRatedElements] PRIMARY KEY NONCLUSTERED 
GO