Creating a Foreign Key on a Diagram

The Create Foreign Key dialog lets you edit the default foreign key properties. You can change the default name of the foreign key column or select another existing column as the foreign key column if you have already created it.

By drawing the foreign key from PERSONS to ADDRESSES, a foreign key with cardinality 1:M is created in ADDRESSES.

You could delete the key from the diagram by right-clicking the relationship and choosing Delete.

Copyright © 1997, 2009, Oracle. All rights reserved.