Foreign Key that doesn't use Primary Key of parent table

gwruck_125 · April 4, 2011, 1:29am

I would like to be able to create foreign keys / relationships using field’s other than the primary key of the parent table.

Toad does not seem to allow this. While I realise that it is a bit obscure to want to this, there are some particular aspects of my application that require it.

Any advice on ways of doing this would be appreciated.

admin1 · April 4, 2011, 9:02am

Hello gwruck_125,

Creation of any Foreign Key is limited to reference/relation to a Unique characteristic, that means the relation must be created with either a Parent Key, a Unique Attribute (Alternate Key), or an Index.

Regards,
Lukas

Message was edited by: dkretek

Topic		Replies	Views
foreign keys Toad Data Modeler	3	1166	May 21, 2010
Non PK to reference PK constraint? Toad Data Modeler	3	798	January 10, 2008
Relationships and adding foreign keys. Toad Data Modeler	1	781	June 2, 2015
Change Primary Key to Foreign Key Toad Data Modeler	1	1111	November 5, 2012
Foreign Keys Toad Data Modeler	1	1049	March 12, 2014

Foreign Key that doesn't use Primary Key of parent table

Related topics