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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s