Online Documentation for SQL Manager for Oracle

DB Explorer

General options


CheckBox Show database groups

Shows/hides database groups in the DB Explorer tree.


CheckBox Show table subobjects

Shows/hides table subobjects (fields, indexes, etc.) in the DB Explorer tree.


CheckBox Show view subobjects

Shows/hides view subobjects (fields, keys, etc.) in the DB Explorer tree.


CheckBox Sort by aliases

Use this option to apply sorting registered databases by their aliases in the DB Explorer tree.


CheckBox Rename objects by editing in place

Allows you to edit object names in DB Explorer by selecting any object and clicking its alias one more time.


CheckBox Refresh objects on showing in SQL Assistant

This option enables/disables refreshing objects each time they are displayed in SQL Assistant.


CheckBox Auto expand navigation pane

Enable this option if you need navigation pane be expanded when the program is launched.


CheckBox Show hints

If this option is selected, popup hints will be shown when setting a cursor on the object in the database explorer.


Recent objects count

Defines the number of objects displayed within the Recent menu of the DB Explorer.

Environment Options - Tools - DB Explorer

Table / Procedure / Function / View / Other objects' details in SQL Assistant

These options switch the SQL Assistant mode for displaying details for Oracle objects selected in the DB Explorer tree:

for tables: fields, primary/unique keys, Foreign keys, checks, indexes, triggers, table status, definition or description;

for views: fields, primary/unique keys, Foreign keys, triggers, definition or description;

for procedures/functions: parameters or definition;

for other objects: definition or description.


See also:

Database Explorer