Database Navigator

Table of contents

• Overview
• Object tree
• Context menu
• Shortcuts
• Configuring Database Navigator in the configuration file

Overview

The Database Navigator is a primary interface component for managing database structures and contents. It is positioned on the left-hand side of the application window. Key elements of the Database Navigator include the Toolbar, the Settings menu, and a hierarchical Object tree.

For details about the options available in the Toolbar and the Settings menu, see the Toolbar and the Settings menu guides.

Object tree

The Database Navigator displays a hierarchical tree that includes the following types of objects:

• Folders
• Database connections
  • Database objects (varying by database type, such as Tables, Views, Indexes, etc.)

Tip: You can store Database connections in folders. For more information, see Database Navigator folders.

Context menu

To access the context menu for an object, hover your cursor over the object in the Database Navigator and click the sandwich button to the right of the object. You can also access the context menu by right-clicking on the object in the Database Navigator.

The table below summarizes the available context menu items for each object type within the tree. The availability of these items depends on the specific database and object types.

Menu item	Description
Open	Opens an object in a separate Document viewer.
Filter	Allows inclusion or exclusion of database objects based on specified criteria. You can apply masks (%, _ and *) to define these criteria.
SQL Editor	Opens a new SQL Editor for the connection. For more information, see SQL Editor.
Connection view	Changes the view of the Database Navigator. For more information, see Simple and advanced view.
Edit Connection	Opens the Connection Configuration window that allows the configuration of connection settings. For more information, see Connection Configuration.
Disconnect	Disconnects from the database.
Disconnect all	Disconnects all database connections.
Delete	Deletes an object. The Delete action is irreversible and will remove the object from both the navigator tree and the database or file system permanently.
Refresh	Refreshes the object’s subnodes – mostly used for refreshing schemas.
Rename	Opens the Rename dialog box for an object.
Generate SQL	Opens a submenu on which you can select the type of SQL query to generate: SELECT, INSERT, UPDATE, DELETE, MERGE, DDL. Clicking one of the items (e.g., INSERT) generates a relevant query in a separate window.
Export	Opens the Export window for table data export. For more information, see Data Export.

Shortcuts

Shortcut	Description
Ctrl + F	Enable filtering
Ctrl + Shift + ,	Link with editor
Ctrl + Shift + /	Collapse all

Configuring Database Navigator in the configuration file

Administrators can customize the Database Navigator settings in the app.defaultNavigatorSettings section of the configuration file. These settings control the visibility and organization of database objects within the navigator.

For more information on how to adjust Database Navigator settings through the configuration file, see the Server configuration.