Database Navigator
Table of contents
Overview
Description
The Database Navigator is the main tool to work with the structure and content of databases. It is located on the left-hand side of the page and has the toolbar, the Settings menu and a tree of objects.
Structure
The Database Navigator contains a tree of objects. Each object in the tree has its own context menu. The tree can contain the following objects:
Folders
Database connections
Database objects - various depending on the database type, such as Tables, Views, Indexes, etc.
To open 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.
The following table summarizes the context menu items for all types of objects that may appear in the tree. Note that the presence or absence of the context menu items for an object depends on the database and object types.
| Menu item | Description |
|---|---|
| Open | Opens an object in a separate Document viewer |
| SQL Editor | Opens a new SQL Editor for the connection |
| Connection view | Changes the view of the Database Navigator |
| Edit Connection | Opens the Connection Configuration window that allows the configuration of connection settings |
| Disconnect | Disconnects from the database |
| Delete | Deletes an object. WARNING! The Delete menu item removes the object not only from the tree but from the database itself or the file system, and this action is irreversible. |
| 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 (for example INSERT) generates a relevant query in a separate window |
| Export | Opens the Export window for table data export |
To establish a database connection, do one of the following:
open the connection;
expand the connection in the Database Navigator;
open the SQL Editor for the connection.
Users can store connections in folders.
Shortcuts
| Shortcut | Description |
|---|---|
| Ctrl + F | Filtering elements in tree |
| Ctrl + Shift + , | Link with Editor |
| Ctrl + Shift + / | Collapse all |