if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_MemberData_MemberData]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[MemberData] DROP CONSTRAINT FK_MemberData_MemberData
GO

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

CREATE TABLE [dbo].[MemberData] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[FirstName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[LastName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address2] [nvarchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
	[City] [nvarchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Zip] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

