Re: Suggestion on FOREIGN KEYs
Quote
1) showed all tables which included FOREIGN KEY definitions,
It does. Reverse engineer your database into EER to see all your tables, with FK definitions.
Quote
Also, fix the issue to allow the FK to be within the CREATE TABLE instead of having to be in a separate ALTER TABLE statement!
It does. While defining your table, define your columns, then select the Foreign Keys tab and define your FK! Note that the tables/columns you want your FK to reference must already exist.
Good luck,
Barry.
Subject
Written By
Posted
Re: Suggestion on FOREIGN KEYs
April 16, 2024 06:15PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.