Database Navigator
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.
Info
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¶
Right-click an object in the Database Navigator, or hover over it and click the menu icon on the right.
The table below lists available actions per object type. Actions vary by database and object type.
| 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. |
| Connection info | Opens a window with information about the current connection. |
| Manage -> Edit Connection | Opens the Connection Configuration window that allows the configuration of connection settings. For more information, see Connection Configuration. |
| Manage -> Clone | Creates a copy of the current connection with the same settings. |
| Disconnect | Disconnects from the database. |
| Disconnect all | Disconnects all database connections. |
| Session Manager | Opens the Session Manager, where you can view and manage active database sessions. For more details, see Session Manager. |
| Manage -> 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. |
| Manage -> 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. |
| Describe object with AI | Describe a selected table, view, or other object using AI. For more information, see Describe database object. |
Tip
You can use keyboard shortcuts to speed up your work in the Database Navigator. See the Shortcuts.
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.
Info
For more information on how to adjust Database Navigator settings through the configuration file, see the Server configuration.