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(UniversityID )
);
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 am not entirely sure what you are trying to accomplish, could you please reword you question a little?|||
Quote:
Originally Posted by Motoma
I am not entirely sure what you are trying to accomplish, could you please reword you question a little?
Ok, Sorry for that. Well, I have created three tables University, Person and Borrower. What I want to do is to have one column in table Borrower (lets say with name MemberId) which will be foreign key referencing together in the other two tables.
For example I gave the below syntax in SQL Server but it does not work:
create table Borrower(
BorrowerID ..........,
................,
..................,
...................,
foreign key (MemberID) references University,
foreign key (MemberID) references Person
);|||So you want the key to exist in either one of the tables? I'm not quite sure of the interaction you are looking for.|||
Quote:
Originally Posted by Motoma
So you want the key to exist in either one of the tables? I'm not quite sure of the interaction you are looking for.
ok I see. I will try to find another way. thanks
 
No comments:
Post a Comment