Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enh. Request: Provide foreign key dependency info. in a table's worksheet

J. Fuda-OracleOct 28 2020

Currently if table A is referenced by foreign key constraints in tables B, C, D, etc. there is no easy way to see a list of tables B, C, D, etc. from table A's object worksheet. Users have to manually execute a query on ALL_CONSTRAINT each time they need this info.
It would be very useful if such a list were easily available when inspecting table A. One of the following potential locations would be suitable.
additional rows in the "Dependencies" tab
a new tab labeled "References" or something similar
a sub tab in the bottom half of the "Constraints" tab whenever a primary key row is selected

Comments
Post Details
Added on Oct 28 2020
3 comments
333 views