Displaying a schema object and its properties

When an object is open in an editing window, and you want to see where that object resides in the schema, you can use the Locate in Schema command to jump to that object’s node in the DB Navigator tree. This action expands all intermediate nodes and displays the object’s details—such as privileges and columns.

The Locate in Schema command is available not only from the object editing windows, but also from the following windows:

$image\Sqln0004.gif$ DB Navigator

$image\Sqln0004.gif$ Find Objects

$image\Sqln0004.gif$ Code Search

$image\Sqln0004.gif$ Workspace

$image\Sqln0004.gif$ Describe tool

$image\Sqln0004.gif$ Analyze tool

$image\Sqln0004.gif$ Browse Data and Edit Data

To locate an open or selected object in the schema

$image\Sqln0006.gif$ Click $image\Sqln0039.gif$ , or from the Object menu, choose Locate in Schema.

$image\Sqln0022.gif$

You can hide the right pane to save screen space or increase the speed of the display.

Click $image\Sqln0040.gif$ (the Show/Hide Details button) on the DB Navigator toolbar

—Or—

Right-click in the DB Navigator window and choose View $image\Sqln0041.gif$ Show/Hide Details from the shortcut menu.

$image\btn_Commands_for_working_with_database_objects60.gif$