Toad World® Forums

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


#1

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.


#2

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