Cannot find user defined datatype 'empnum' in SQL Server 2014

Viewed 1942

When I run the following query in SQL Server 2014 to create a temporary table:

CREATE TABLE #temp 
(   
    location char(16) null, 
    location_desc varchar(25) null, 
    Emp_Num EMPNUM null
)

I receive the error:

Cannot find the data type empnum.

empnum is a user-defined data type. But the same user-defined data type is working fine in other stored procedures.

Why am I receiving this error?

2 Answers
Related