/****** Object: Table [dbo].[cikk_chipsado] Script Date: 06/28/2012 14:30:11 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cikk_chipsado]') AND type in (N'U')) DROP TABLE [dbo].[cikk_chipsado] GO /****** Object: Table [dbo].[cikk_chipsado] Script Date: 06/28/2012 14:30:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[cikk_chipsado]( [cikk_szam] [char](14) NOT NULL, [norm1] [numeric](18, 3) NOT NULL, [norm2] [numeric](18, 3) NOT NULL, [norm3] [numeric](18, 3) NOT NULL, [norm4] [numeric](18, 3) NOT NULL, [norm5] [numeric](18, 3) NOT NULL, [norm6] [numeric](18, 3) NOT NULL, [norm7] [numeric](18, 3) NOT NULL, [norm8] [numeric](18, 3) NOT NULL, [norm9] [numeric](18, 3) NOT NULL, [norm10] [numeric](18, 3) NOT NULL, [kat1] [numeric](18, 3) NOT NULL, [kat2] [numeric](18, 3) NOT NULL, [kat3] [numeric](18, 3) NOT NULL, [kat4] [numeric](18, 3) NOT NULL, [kat5] [numeric](18, 3) NOT NULL, [kat6] [numeric](18, 3) NOT NULL, [kat7] [numeric](18, 3) NOT NULL, [kat8] [numeric](18, 3) NOT NULL, [kat9] [numeric](18, 3) NOT NULL, [kat10] [numeric](18, 3) NOT NULL, CONSTRAINT [PK_cikk_chipsado] PRIMARY KEY CLUSTERED ( [cikk_szam] 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 SET ANSI_PADDING OFF GO