if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblPeople]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblPeople]
GO

CREATE TABLE [dbo].[tblPeople] (
	[pkPersonID] [int] IDENTITY (1, 1) NOT NULL ,
	[LastName] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[FirstName] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Title] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CompanyName] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Address] [varchar] (240) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[HomePhone] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[WorkPhone] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Fax] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Email] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[WebPage] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Notes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[tblPeople] WITH NOCHECK ADD 
	CONSTRAINT [PK_tblPeople] PRIMARY KEY  CLUSTERED 
	(
		[pkPersonID]
	)  ON [PRIMARY] 
GO

