Hello,
I have a problem with foreign key. What I want to do is , have one foreign key referencing in two different tables! I have created three tables:
create table University(
UniversityID int not null,
Name nvarchar(50),
.....
.....
.....
primary key(UniversityI D )
);
create table Person(
PersonID int not null,
Name nvarchar(50),
.....
.....
.....
primary key(PersonID )
);
create table Borrower(
BorrowerID int not null,
Name nvarchar(50),
MemberName int,
.....
.....
.....
primary key(BorrowerID )
foreign key(MemberName) reference University,
foreign key(MemberName) reference Person,
);
So I want to have one column (in my example MemeberName) which referencing in two different tables. How can I do that??
I have a problem with foreign key. What I want to do is , have one foreign key referencing in two different tables! I have created three tables:
create table University(
UniversityID int not null,
Name nvarchar(50),
.....
.....
.....
primary key(UniversityI D )
);
create table Person(
PersonID int not null,
Name nvarchar(50),
.....
.....
.....
primary key(PersonID )
);
create table Borrower(
BorrowerID int not null,
Name nvarchar(50),
MemberName int,
.....
.....
.....
primary key(BorrowerID )
foreign key(MemberName) reference University,
foreign key(MemberName) reference Person,
);
So I want to have one column (in my example MemeberName) which referencing in two different tables. How can I do that??
Comment