if not exists (select * from sys.columns where object_id = object_id('dbo.MyTable') and name = 'NewColumn')
begin
alter table Customer.Configuration add NewColumn int null
end
do something with the new column - update, alter, etc.
--> Error message:
Msg 207, Level 16, State 1, Server <MyServer>, Line 17 Invalid column name 'NewColumn'.
Solution:
Close the batch pf the creation by adding 'GO' between the column creatuion and usage.
if not exists (select * from sys.columns where object_id = object_id('dbo.MyTable') and name = 'NewColumn')
begin
alter table Customer.Configuration add NewColumn int null
end
GO
do something with the new column - update, alter, etc.
