SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[PS_EMAIL_ADDRESSES]( [EMPLID] [varchar](11) NOT NULL, [E_ADDR_TYPE] [varchar](4) NOT NULL, [EMAIL_ADDR] [varchar](70) NOT NULL, [PREF_EMAIL_FLAG] [varchar](1) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF