I have two tables, tableA with ID as a primary key and tableB which has two fields (apart from several other fields)...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
that are IDs from tableA. Can I create a foreign key relationship between them? The basic relationship is one-to-many.
Yes. In fact, this is quite common:
create table tableA ( ID integer not null , AName varchar(5) not null , constraint A_pk primary key (ID) ) create table tableB ( AID1 integer not null , AID2 integer not null , Bstuff varchar(9) not null , constraint B_pk primary key (AID1,AID2) , constraint B_fkA1 foreign key (AID1) references tableA (ID) , constraint B_fkA2 foreign key (AID2) references tableA (ID) )
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.