Novo campo na tabela

if not exists(select name from sys.columns s where OBJECT_NAME(s.object_id) = 'TABELA' and name = 'CAMPO')

begin

ALTER TABLE TABELA add CAMPO varchar(8000);

end

go