-- Add new column if column not exists IF NOT EXISTS(SELECT * FROM sys.columns WHERE Name = N'ColumnName' AND Object_ID = Object_ID(N'TableName')) ALTER TABLE [TableName] ADD [ColumnName] VARCHAR(200) -- Modify column name if new column not exists IF NOT EXISTS(SELECT * FROM sys.columns WHERE Name = N'NewColumnName' AND Object_ID = Object_ID(N'TableName')) EXECUTE sp_rename N'TableName.OldColumnName', N'NewColumnName', 'COLUMN'