USE [Db] GO /****** Object: Table [dbo].[SHABHD] Script Date: 09/14/2012 09:09:10 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SHABHD]( [SHDLFN] [numeric](10, 0) NOT NULL, [SHDFLG] [char](1) NULL, [SHDKLS] [char](2) NULL, [SHDART] [char](4) NULL, [SHDSHN] [numeric](5, 0) NULL, [SHDSHS] [numeric](5, 0) NULL, [SHDSHD] [numeric](8, 0) NULL, [SHDAMB] [char](1) NULL, [SHDKTO] [char](2) NULL, [SHDMLN] [char](10) NULL, [SHDVON] [numeric](2, 0) NULL, [SHDETD] [numeric](8, 0) NULL, [SHDNTG] [char](1) NULL, [SHDORS] [char](2) NULL, [SHDPRS] [char](1) NULL, [SHDNA] [char](250) NULL, [SHDSP] [char](2) NULL, [SHDNA1] [char](250) NULL, [SHDSP1] [char](2) NULL, [SHDNA2] [char](250) NULL, [SHDSP2] [char](2) NULL, [SHDNA3] [char](250) NULL, [SHDSP3] [char](2) NULL, [SHDNA4] [char](250) NULL, [SHDSP4] [char](2) NULL, [SHDNB] [char](250) NULL, [SHDSC] [char](2) NULL, [SHDNB1] [char](250) NULL, [SHDSC1] [char](2) NULL, [SHDNB2] [char](250) NULL, [SHDSC2] [char](2) NULL, [SHDNB3] [char](250) NULL, [SHDSC3] [char](2) NULL, [SHDNB4] [char](250) NULL, [SHDSC4] [char](2) NULL, [SHDZUN] [char](250) NULL, [SHDRFO] [char](2) NULL, [SHDSZS] [char](40) NULL, [SHDSZC] [char](80) NULL, [SHDSZF] [char](20) NULL, [SHDSZP] [numeric](5, 0) NULL, [SHDSZO] [char](30) NULL, [SHDSZZ] [char](30) NULL, [SHDSZL] [char](30) NULL, [SHDSBS] [char](40) NULL, [SHDSBC] [char](80) NULL, [SHDSBF] [char](20) NULL, [SHDSBP] [numeric](5, 0) NULL, [SHDSBO] [char](30) NULL, [SHDSBZ] [char](30) NULL, [SHDSBL] [char](30) NULL, [SHDHSS] [char](40) NULL, [SHDHSC] [char](80) NULL, [SHDHSF] [char](20) NULL, [SHDHSP] [numeric](5, 0) NULL, [SHDHSO] [char](30) NULL, [SHDHSZ] [char](30) NULL, [SHDHSL] [char](30) NULL, [SHDZWS] [char](1) NULL, [SHDADAN] [char](80) NULL, [SHDADS] [char](40) NULL, [SHDADSZ] [char](40) NULL, [SHDADC] [char](80) NULL, [SHDADF] [char](20) NULL, [SHDADP] [numeric](5, 0) NULL, [SHDADO] [char](30) NULL, [SHDADZ] [char](30) NULL, [SHDADL] [char](30) NULL, [SHDABAN] [char](80) NULL, [SHDABS] [char](40) NULL, [SHDABSZ] [char](40) NULL, [SHDABC] [char](80) NULL, [SHDABF] [char](20) NULL, [SHDABP] [numeric](5, 0) NULL, [SHDABO] [char](30) NULL, [SHDABZ] [char](30) NULL, [SHDABL] [char](30) NULL, [SHDNEU] [char](1) NULL, [SHDRFN] [numeric](5, 0) NULL, [SHDRFS] [numeric](5, 0) NULL, [SHDRFD] [numeric](8, 0) NULL, [SHDRFM] [char](10) NULL, [SHDZWK] [char](100) NULL, [PXEHRA] [char](6) NULL, [PXCHNR] [char](13) NULL, [SHZART] [char](4) NULL, [SHZVER] [char](10) NULL, [SHDSTA] [char](10) NULL, PRIMARY KEY CLUSTERED ( [SHDLFN] 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