ThatJeffSmith

SQL Developer Quick Tip: GOTO in the Schema Browser

It’s a relational database, so it’s only a matter of time before you stumble across an object that’s dependent on another object, right?

If you are looking at a table in the browser, be sure to check out the ‘Dependencies’ page. This page displays the database objects that will be upset if the selected table were to ‘go away.’ You’re probably familiar with these related objects, but if not, then there’s a quick ‘trick’ to investigate further.

Let’s take a look at SH.SALES as an example:

Auto-navigate to the selected object in the grid

This takes me to SH.CAL_MONTH_SALES_MV, a materialized view.

When I’m done poking around, I might want to go back to my SALES table.

The ‘Back’ and ‘Forward’ buttons on the main toolbar serve as my Most-Recently-Used tree navigation buttons.

If you can work a web browser, you can mostly work SQL Developer, mostly