dbo.People

Modify to suit – I just saved a few minutes of your time. You’re welcome!

IF NOT EXISTS ( SELECT *
                FROM   sys.objects
                WHERE  object_id = OBJECT_ID(N'dbo.People')
                       AND type in (N'U')
)
BEGIN
  CREATE TABLE dbo.People (
     ID BIGINT PRIMARY KEY IDENTITY(1,1),
     Salutation NVARCHAR(30) , -- Mr, Mrs, Dr, Miss, etc.
     Title NVARCHAR(100) , --
     FirstName1 NVARCHAR(50) ,
     FirstName2 NVARCHAR(50) ,
     MiddleName1 NVARCHAR(50) ,
     MiddleName2 NVARCHAR(50) ,
     MiddleInitial CHAR(1) ,
     LastName1 NVARCHAR(100) ,
     LastName2 NVARCHAR(100) ,
     Suffix NVARCHAR(30) );
END
GO
Advertisements