PembsEDs.txt

create table statement for sql server table - Dave Morgan, 2014-04-25 01:17 AM

Download (859 Bytes)

 
1
/****** Object:  Table [GovernmentAreas].[ElectoralDivisions]    Script Date: 04/25/2014 09:15:16 ******/
2
SET ANSI_NULLS ON
3
GO
4

    
5
SET QUOTED_IDENTIFIER ON
6
GO
7

    
8
SET ANSI_PADDING ON
9
GO
10

    
11
CREATE TABLE [GovernmentAreas].[ElectoralDivisions](
12
	[ONS_ID] [varchar](10) NULL,
13
	[Name] [varchar](60) NULL,
14
	[Member_Name] [varchar](35) NULL,
15
	[Party] [varchar](30) NULL,
16
	[Information] [varchar](150) NULL,
17
	[Electorate] [int] NULL,
18
	[Enw] [varchar](60) NULL,
19
	[Plaid] [varchar](30) NULL,
20
	[MI_STYLE] [varchar](254) NULL,
21
	[MI_PRINX] [int] IDENTITY(1,1) NOT NULL,
22
	[SP_GEOMETRY] [geometry] NULL,
23
PRIMARY KEY CLUSTERED 
24
(
25
	[MI_PRINX] ASC
26
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
27
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
28

    
29
GO
30

    
31
SET ANSI_PADDING OFF
32
GO