Yesterday I needed to find what tables were referencing a particular table in Oracle. These days I'm working with Oracle SQL Developer, and being a guy used to MS SQL Server Tools, I thought that the option should be somewhere in the GUI, but to my surprise there wasn't any such option. Thankfully the solution was just a google-search away.
In this thread at stackoverflow user junaling explains how to add the functionality to Oracle SQL Developer:
http://stackoverflow.com/a/8230251/1299317
Maybe it's worth to mention that the result of adding the user defined extension to Oracle SQL Developer is that you will see a new tab named FK References in the table information window (the one that you see whenever you click on a table on the Connections window).
No comments:
Post a Comment