Reputation: 187
Can, for example,
table1.columnA reference table2.columnA
if table2.columnA is not a primary key? Or is referencing strictly for primary keys?
Upvotes: 0
Views: 30
Reputation: 17934
There must be a unique constraint on table2.columnA
in order to reference it in a FOREIGN KEY
constraint. But it need not be the primary key.
Upvotes: 3