Opening, Closing and Pinning Tabs
You work with database objects and scripts in tabs in the work area. This page describes how to open tabs, close them, and pin tabs that you want to keep.
Opening tabs
Database objects
Database objects are the tables, views, procedures and other objects in the Databases tab. To open one, for example a table, double-click its node in the Databases tab, or select the node and press Enter. You can also right-click the node and select Open Object → Open in Tab, or use the Open Object button in the Databases tab toolbar.
The object opens in an Object View tab, where you see its data, columns and other information. By default, DbVisualizer reuses an available tab: the current tab, or another one that isn't pinned, busy or holding unsaved edits. If there is none, a new tab opens. If the object is already open in a tab, that tab is shown.
To open a new tab instead, do one of these:
- Hold down
Altwhen you double-click the node. - Right-click the node and select Open Object → Open in New Tab.
- Select Open in New Tab using the Open Object button. The button remembers the last choice, so the next time, you only need to click it.
To stop reusing tabs for other objects, set Tab selection when requesting "Open in Tab" to 1) Existing Tab 2) New Tab, in the General / Tabs category in Tools → Tool Properties. What a double-click does is set in the General / Database Objects Tree category.
Open in Tab and Open in New Tab also work for several selected nodes at once.
To show another object in an existing Object View tab, drag its node from the tree to the tab header.
To select the node in the tree when you select an Object View tab, and the other way around, see Keeping the tree and the tabs in sync.
Scripts
To open a script, double-click it in the Files tab, or right-click it and select Open in SQL Commander. To open and run it at once, select Open in SQL Commander and Execute. A script always opens in a new SQL Commander tab, unless it is already open.
To open a new, empty SQL Commander tab, press Ctrl+T (Cmd+T on macOS), select SQL Commander → New SQL Commander, or click New in the main toolbar.
To open files from the file system in SQL Commander, select File → Open, or click Open in the main toolbar. You can also drag files from your file browser to the main toolbar. Each file opens in a new SQL Commander tab.
Closing tabs
To close a tab, press Ctrl+W (Cmd+W on macOS), click the cross next to its label, or click the tab header with the middle mouse button. This also works for Result Set tabs in SQL Commander.
To close several tabs, right-click a tab header and select one of these:
| Action | Description |
|---|---|
| Close Tab | Close the current tab, even if it is pinned. |
| Close Other Tabs | Close all unpinned tabs except the current tab. |
| Close Tabs to the Right | Close unpinned tabs to the right of the current tab. |
| Close All Pinned Tabs | Close all pinned tabs. |
| Close All Tabs | Close all unpinned tabs. |
Pinning tabs
Pin the tabs that you want to keep while you work with other objects and scripts. A pinned tab:
- Isn't reused when you open another object. For example, pin the Object View tab of a table that you often look at, and other objects open in other tabs.
- Isn't closed by Close Other Tabs, Close Tabs to the Right or Close All Tabs. So you can clean up the work area and keep the tabs you need.
A pinned tab is closed only when you close it yourself, or with Close All Pinned Tabs.
To pin a tab, right-click its header and select Pin Tab, or press Alt (Option on macOS) and click the header. A pin is shown on the tab icon. To unpin the tab, do the same again. To pin or unpin all tabs, select Pin All or Unpin All.