SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[PSXLATITEM]( [FIELDNAME] [varchar](18) NOT NULL, [FIELDVALUE] [varchar](4) NOT NULL, [EFFDT] [dbo].[PSDATE] NULL, [EFF_STATUS] [varchar](1) NOT NULL, [XLATLONGNAME] [varchar](30) NOT NULL, [XLATSHORTNAME] [varchar](10) NOT NULL, [LASTUPDDTTM] [dbo].[PSDATETIME] NULL, [LASTUPDOPRID] [varchar](30) NOT NULL, [SYNCID] [int] NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF