IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Advertis' AND COLUMN_NAME = 'AddUser') BEGIN ALTER TABLE [Advertis] ADD [AddUser] int END ELSE BEGIN ALTER TABLE [Advertis] ADD [AddUserTemporary] int UPDATE [Advertis] SET [AddUserTemporary]=AddUser ALTER TABLE [Advertis] DROP COLUMN [AddUser] EXEC sp_RENAME 'Advertis.AddUser-Temporary', 'AddUser' , 'COLUMN' END