VARCHAR2 is not a valid data type in SQL Server.

Try the following

create table tbl (

name as varchar(50) not null

)

GO

insert into tbl (name)

Select name from account union

Select name from customer union

Select name from party