Thursday, May 10, 2012

Oracle SQL Developer FK References

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).