[dba-SQLServer] Strange Create Table Syntax

Never mind - I found the Create Type command.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David
Emerson
Sent: Tuesday, 18 March 2014 9:33 a.m.
To: AccessDSQL
Subject: [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

 

 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com