[dba-SQLServer] Strange Create Table Syntax

David Emerson newsgrps at dalyn.co.nz
Mon Mar 17 15:33:02 CDT 2014


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

 

 



More information about the dba-SQLServer mailing list