SQLize | PHPize | SQLtest

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TXN_INVDELIVERY]') AND TYPE=N'U') BEGIN CREATE TABLE [dbo].[TXN_INVDELIVERY]( [DIST_CD] [nvarchar](20) NOT NULL, [TXN_KEY] [nvarchar](50) NOT NULL, [TXN_NO] [nvarchar](30) NOT NULL, [VISIT_KEY] [nvarchar](50) NOT NULL, [PICKLIST_KEY] [nvarchar](50) NOT NULL, [INV_KEY] [nvarchar](50) NOT NULL, [DELIVERY_REP] [nvarchar](20) NOT NULL, [CUST_CD] [nvarchar](20) NOT NULL, [TXN_DT] [date] NOT NULL, [INV_DELIVERY_STATUS] [char](1) NOT NULL, [PROCESS_STATUS] [char](1) NOT NULL, [HHT_SUBMIT_DT] [datetime] NULL, [PROCESS_DT] [datetime] NULL, CONSTRAINT [PK_TXN_INVDELIVERY] PRIMARY KEY CLUSTERED ( [TXN_KEY] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] ALTER TABLE [dbo].[TXN_INVDELIVERY] ADD CONSTRAINT [DF_TXN_INVDELIVERY_PROCESS_STATUS] DEFAULT ('P') FOR [PROCESS_STATUS] END