CREATE TABLE [dbo].[PS_PERSONAL_PHONE]( [EMPLID] [char](11) NOT NULL, [PHONE_TYPE] [char](4) NOT NULL, [COUNTRY_CODE] [char](3) NOT NULL, [PHONE] [char](24) NOT NULL, [EXTENSION] [char](6) NOT NULL, [PREF_PHONE_FLAG] [char](1) NOT NULL ) ON [PRIMARY]