if exists(select * from Sysobjects where Xtype='U' and ltrim(rtrim(Name))='Ethnicity_Master') begin drop table Ethnicity_Master CREATE TABLE Ethnicity_Master ( Ethnicity_ID int primary key identity (1,1) not null, Race_ID int , Ethnicity_Description nvarchar(500), foreign key (Race_ID) references Race_Master(Race_ID) on delete cascade ) end else Begin CREATE TABLE Ethnicity_Master ( Ethnicity_ID int primary key identity (1,1) not null, Race_ID int , Ethnicity_Description nvarchar(500), foreign key (Race_ID) references Race_Master(Race_ID) on delete cascade ) End insert into Ethnicity_Master(Race_ID,Ethnicity_Description) values(1,'European') insert into Ethnicity_Master(Race_ID,Ethnicity_Description) values(1,'Armenian') insert into Ethnicity_Master(Race_ID,Ethnicity_Description) values(1,'English')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)