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 email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.