Database Tool Window
On this page:
- Overview of the tool window
- View options
- Toolbar icons, context menu commands and shortcuts
- Icons for data sources and their elements
See also, Working with the Database Tool Window.
Overview of the tool window
The Database tool window provides access to functions for working with databases and DDL data sources. It lets you view and modify data structures in your databases, and perform other associated tasks.
The available data sources are shown as a tree of data sources, schemas, tables and columns. If no data sources are currently defined, use the New command (Alt+Insert) to create a data source.
Most of the functions in this window are accessed by means of the toolbar icons or context menu commands. (If the toolbar is not currently shown, click on the title bar and select Show Toolbar.) Many of the commands have keyboard shortcuts. If the toolbar is hidden, the Synchronize and Console commands can be access by means of the title bar icons ( and respectively).
The set of available functions depends, first of all, on the data source type (DB or DDL). For DB data sources you can, for example:
- Create, modify and delete database tables, table columns, indexes, primary and foreign key constraints, etc. The following commands are provided for these purposes: New, Rename, Modify Column, Drop and Drop Associated (e.g. Drop Associated Primary Key).
- Open the Table Editor to manipulate table data (the Table Editor command).
- Open the database console to run DDL and DML SQL statements (the Console command). You can also create new consoles: New .
- Generate DDL definitions for databases and database tables. The corresponding definitions are generated on the clipboard by using the Copy DDL command, and then may be pasted into a file or the database console.
- Save table data in various "most popular" formats (the Save to File command).
Irrespective of the data source type (DB or DDL), you can also:
- Compare the data sources and tables (the Compare command).
- View UML class diagrams for data sources and tables (the Diagrams command).
- View basic information for data sources and their elements in a quick documentation pop-up.
- Set and change colors for data sources, tables and columns (the Color Settings command).
on the title bar provides access to view options.
The view options, generally, define what is shown in the tool window and how. To view or change these options, click on the title bar.
This option defines how schema elements are shown.
When on, there are separate nodes for tables, views and stored routines (shown as folders). Tables, views and routines (procedures and functions) are shown as elements of the corresponding groups.
When off, there is no explicit grouping for tables, views, and routines. Tables and views are followed by procedures and functions.
This option defines how table elements are shown.
When on, there are separate nodes for columns, indexes, primary and foreign key constraints, and triggers (shown as folders). The elements appear in the corresponding groups.
When off, there is no such grouping and, generally, only columns are shown for tables.
|Show Keys and etc.||
When this option is on, the public and foreign key constraints, and indexes are shown.
Otherwise, the constraints are not shown.
The option is unavailable when the Group Contents option is on.
When this option is off, columns, generally, are unsorted.
When this option is on, the columns are ordered like this: the columns with a primary key, then the columns with a foreign key, and then the rest of the columns. Within the groups, the columns are ordered alphabetically.
|Show Toolbar||Select or deselect this option to show or hide the toolbar.|
The rest of the options are common for all the tool windows, see Viewing Modes.
Toolbar icons, context menu commands and shortcuts
|New||Alt+Insert||Use this icon, command or shortcut to create a new data source, database console, table, column, index, or a primary or foreign key.
The list of options depends on which element is currently selected.
||DB data sources and their elements (tables and table columns). If a DDL data source is selected, you can only choose to create another data source.|
|Disconnect||Ctrl+F2||Use this icon, command or shortcut to close the database connection for the selected DB data source or data sources. (The names of the data sources with active database connections are shown in bold.)||DB data sources with active connections and their elements|
Use this command to remove constraints such as a primary key or a foreign key constraint.
||Tables and table columns in DB data sources|
|Rename||Shift+F6||Use this command or shortcut to rename the selected data source, table or table column. Specify the new name in the dialog that opens.||All node types|
|Duplicate||Ctrl+D||Use this icon, command or shortcut to create a copy of the selected data source. Specify the properties of the data source in the Data Sources and Drivers dialog that opens. See Data Sources and Drivers Dialog.||DB and DDL data source nodes|
|Modify Column||Ctrl+F6||Use this command or shortcut to edit the properties of the selected column.||Table columns in DB data sources|
|Copy Reference||Ctrl+Shift+Alt+C||Use this command or shortcut to copy the fully qualified name of the selected data source, table or table column to the clipboard.||All node types|
|Drop||Delete||Use this command or shortcut to delete the selected data source, table or column.||All node types|
|Find Usages||Alt+F7||Use this command or shortcut to find the usages of (references to) the selected item (data source, table or table column) in the project source files and libraries.||All node types|
|Compare||Ctrl+D||Select two data sources or tables and then use this command or shortcut to compare the selected items. The differences are shown in Differences Viewer for Folders and DB Objects.||DB and DDL data sources and tables|
|Table Editor||F4||Use this icon, command or shortcut to open the selected database table in the Table Editor.
See also, Working with the Table Editor.
|Tables and table columns in DB data sources|
Procedure Editor or
|F4||Use this icon, command or shortcut to open the definition of the selected view, function, procedure or package in the editor.||Corresponding elements in DB data sources|
|Edit Source||F4||Use this icon, command or shortcut to open the associated DDL file in the editor.||Tables and table columns in DDL data sources|
|Open Console||Ctrl+Shift+F10||Use this icon, command or shortcut to open the default database console for the corresponding DB data source.||DB data sources and their elements (tables and table columns)|
|Open New Console||Use this command to create and open a new database console for the corresponding DB data source.||DB data sources and their elements (tables and table columns)|
|Synchronize||Ctrl+Alt+Y||Use this icon, command or shortcut to update the view of the selected element
(i.e. to synchronize the view of the element with its actual state in the database).
See also, Auto sync.
|DB data sources and their elements (tables and table columns)|
|Properties||Use this icon or command to open the Data Sources and Drivers dialog to manage your data sources and their settings.||DB and DDL data source nodes|
|Copy DDL||Ctrl+Shift+C||Use this command or shortcut to copy a DDL definition of the selected data source, table or column onto the clipboard.||All node types|
|Save Data to File||Use this command to save the data for the selected table or view in a file, or to view or edit the settings for delimiter-separated values output formats. Select the output format or Configure CSV Formats. In the latter case, the CSV Formats Dialog will open and you'll be able to edit the settings for existing formats, and define new output formats.||Tables in DB data sources|
|Color Settings||Use this command if you want to set or change the color for the selected element or elements. (The Database Color Settings dialog will open.)||All node types|
command or shortcut to see a UML class diagram for the selected data source or table. Select:
||DB and DDL data sources and tables|
Use this icon to collapse all the nodes.
As a result, only your data sources will be shown (i. e. the topmost hierarchy level).
Alternatively, on the title bar can be used.
|All node types|
Use this key combination to see basic information about the selected element.
The information shown depends on the element type.
For example, the info about a table includes
the names of the data source, catalog, schema and the table itself,
the table definition (|
To close the documentation pop-up, press Escape.
|All node types|
Icons for data sources and their elements
|DB data source. Also, DBMS-specific icons are used:|
|DB data source with the read-only status, e.g. for DB2.|
|DDL data source|
|Column with a primary key|
|Column with a foreign key|
|Column with an index|
|Stored procedure or function|