IF ( select count(sc.table_id) from sys.syscolumn as sc == sys.systable as st
  where LCase(st.table_name)= LCase('Hotels') and LCase(sc.column_name)= LCase('UniN') ) = 0 then
    alter table Hotels
	  add UniN integer
end if
go