[dba-SQLServer] Strange Create Table Syntax

Hi Listers,

 

I have been given a script to run to create a set of SQL Tables as follows:

 

CREATE TABLE [dbo].[empabsence](

      [emp_num] [dbo].[EmpNumType] NOT NULL,

      [date_abs] [dbo].[DateType] NOT NULL,

      [hrs] [dbo].[AbsenceHoursType] NULL CONSTRAINT [DF_empabsence_hrs]
DEFAULT ((0)),

Etc

 

When I run the script I get an error 

Msg 2715, Level 16, State 7, Line 1

Column, parameter, or variable #1: Cannot find data type dbo.EmpNumType.

 

I do not have access to the original database so can't do any checking.
Where would the dbo.EmpNumType type be created?

 

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand