USE [test23]
GO

/****** Object:  Table [Schema].[Roads]    Script Date: 10/16/2009 11:51:46 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [Schema].[Roads](
	[Autogenerated_SDF_ID] [bigint] IDENTITY(1,1) NOT NULL,
	[ST_NAME] [nvarchar](255) NULL,
	[ST_TYPE] [nvarchar](255) NULL,
	[SEG_ID] [int] NULL,
	[LENGTH] [float] NULL,
	[ZIPL] [int] NULL,
	[ZIPR] [int] NULL,
	[L_F_ADD] [int] NULL,
	[L_T_ADD] [int] NULL,
	[R_F_ADD] [int] NULL,
	[R_T_ADD] [int] NULL,
	[PREFIX] [nvarchar](255) NULL,
	[NAME] [nvarchar](255) NULL,
	[TYPE] [nvarchar](255) NULL,
	[SUFFIX] [nvarchar](255) NULL,
	[Geometry] [geometry] NULL,
 CONSTRAINT [pk_schema_roads] PRIMARY KEY CLUSTERED 
(
	[Autogenerated_SDF_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


