Database tool window

New

AltInsert

Create a new data source, role, database, schema, query console, table, column, index, or a primary or a foreign key. The list of options depends on which element is currently selected.

Data sources and their elements. If a DDL data source is selected, you can only choose to create another data source.

Data Source Properties

ShiftEnter

Open the Data Sources and Drivers dialog to manage your data sources and their settings.

All node types

Refresh

CtrlF5

Update the view of the selected element (that is to synchronize the view of the element with its actual state in the database).

See also, Data Sources and Drivers dialog.

Data sources and their elements.

Deactivate CtrlF2

CtrlF2

Close the database connection for the selected data source or data sources. (The data sources with connected sessions are indicated with a green dot in the corner of their icon.)

Data sources with active connections and their elements

Jump to Query Console

CtrlShiftF10

Open the list of query consoles for the selected data source.

Data sources and their elements (tables and table columns)

Edit Data

F4

Open a table view of the object in the data editor. This option works for tables, views, and materialized views.

Corresponding elements in data sources.

DDL

Go to DDL

Ctrl0B

Open the DDL script of the selected object.

For example, if you press this shortcut on a table's name in the SELECT statement, you will see the DDL of this table (the CREATE TABLE statement).

note

The object references in the generated script are not qualified (for example, <view_name> instead of <schema_name>.<view_name>). You can view this script, edit it, and submit your changes to the database.

For a runnable DDL script that includes CREATE OR REPLACE, qualified references, and so on, use the SQL Generator.

Corresponding elements in data sources.

Compare Structure

Ctrl0D

Compare the structure of two database objects in the Migration dialog.

Two selected database objects of the same kind.

View Options

Open the list of database object tree viewing options, including the item filter. For more information about the options, refer to the View Options chapter.

All items.

Properties

ShiftEnter

Open the Data Sources and Drivers dialog to manage your data sources and their settings.

Data source and DDL data source nodes.

New

AltInsert

Create a new data source, role, database, schema, query console, table, column, index, a primary, or a foreign key. The list of options depends on which element is currently selected.

Data sources and their elements. If a DDL data source is selected, you can only choose to create another data source.

Rename

ShiftF6

Rename the selected item. Specify the new name in the dialog that opens.

Data sources and their elements.

Copy/Paste | Copy Reference

CtrlAltShift0C

Copy the fully qualified name of the selected item to the clipboard.

Data sources and their elements.

Copy/Paste | Duplicate

Ctrl0D

Create a copy of the selected data source. Specify the properties of the data source in the Data Sources and Drivers dialog that opens.

Data source and DDL data source nodes.

Edit Data

F4

Open a table view of the object in the data editor. This option works for tables, views, and materialized views.

Corresponding elements in data sources.

Move to Folder

F6

Move the selected data source to a folder. If no folders exist yet, create the first one in the Move to Folder popup that appears.

For more information about grouping data sources, refer to Group data sources in folders.

Data source and DDL data source nodes.

Refresh

CtrlF5

Update the view of the selected element (that is to synchronize the view of the element with its actual state in the database).

See also, Data Sources and Drivers dialog.

Data sources and their elements.

Deactivate CtrlF2

CtrlF2

Close the database connection for the selected data source or data sources. (The data sources with connected sessions are indicated with a green dot in the corner of their icon.)

Data sources with active connections and their elements

Drop

or

Remove Data Source

Delete

Remove the selected item.

Data sources and their elements.

Quick Documentation

Ctrl0Q

View basic information about the selected element.

To close the documentation popup, press Esc.

For full information about quick documentation, refer to quick documentation.

Data sources and their elements.

Navigation | Go to DDL

Ctrl0B

Open the DDL script of the selected object.

For example, if you press this shortcut on a table's name in the SELECT statement, you will see the DDL of this table (the CREATE TABLE statement).

note

The object references in the generated script are not qualified (for example, <view_name> instead of <schema_name>.<view_name>). You can view this script, edit it, and submit your changes to the database.

For a runnable DDL script that includes CREATE OR REPLACE, qualified references, and so on, use the SQL Generator.

Corresponding elements in data sources.

Navigation | Jump to Query Console

CtrlShiftF10

Open the list of query consoles for the selected data source.

Data sources and their elements (tables and table columns)

Run Function

or

Run Procedure

Run the selected function or procedure.

Data source elements: functions, procedures.

(Oracle only) Introspection Level

Change the introspection level either for the whole database or for a particular schema. Children inherit a level that is set for a parent.

Oracle Data Source nodes.

SQL Scripts | SQL Generator

CtrlAlt0G

Generate data definition structures for database objects. For example, you can generate DDL files for a single table or for all the tables in the schema. Also, you can customize generation settings. For example, you can set what syntax to use for table creation: CREATE TABLE or CREATE TABLE IF NOT EXISTS.

For more information about using SQL Generator, refer to the Generate DDL definitions for database objects and Change output settings of the SQL Generator chapters.

Data source elements.

SQL Scripts | Generate DDL to Clipboard

CtrlAltShift0G

Generate a DDL of the object and copy it to the clipboard.

Data sources and their elements.

SQL Scripts | Truncate…

Remove all the rows in the selected table.

Data source elements: tables.

Tools | Manage Shown Schemas

Open a popup with available schemas for the current data source.

See also, Show and hide schemas.

Data sources and their elements.

Tools | Compare Structure

Ctrl0D

Compare structures of two selected database objects (data sources, schemas, or tables). The comparison results are shown in the Diff Viewer.

Data sources and their elements.

Tools | Full-text Search

ShiftCtrlAlt0F

Search for data in your databases or a group of databases without knowing the data's exact location.

For more information about the full-text search, refer to Full-text search in databases.

Data sources and their elements.

Tools | Set Color

Set or change the color for the selected element or elements. (The Database Color Settings dialog will open.)

To set a color, right-click a data source and select Tools | Set Color. In the Database Color Settings dialog, select the dialog and coloring options.

To apply the data source color to query consoles and grids, select the In console editors and grids checkbox.

See also, Assign a color to query consoles and grids.

Data sources and their elements.

Tools | Add Bookmark

F11

Add the selected item to bookmarks.

Data sources and their elements.

Tools | Scripted Extensions | Generate POJOs.clj

Generate a Java entity class for the selected table. In the dialog that opens, specify the directory in which the JAVA class file should be generated.

Data sources and their elements.

Tools | Scripted Extensions | Go To Scripts Directory

Switch to the directory where the Generate POJOs.clj example script file is located.

Data sources and their elements.

Import/Export | Export Data to File

Save data for the selected tables and views in files. Select the output format (for example, SQL Inserts, Tab-separated (TSV), JSON-Clojure.json.clj).

Data source elements: tables and views.

Import/Export | Import Data from File(s)…

Import a text file containing delimiter-separated values (CSV, TSV, and so on) into your database.

If a schema is currently selected, IntelliJ IDEA will create a new table for the data that you are importing. If a table is selected, IntelliJ IDEA will try to add the data to the selected table.

Data source elements: tables.

Import/Export | Copy Table to

F5

Create a copy of the selected table. You can create a copy in a different scheme or data source. For example, you can copy the actor table from MySQL to PostgreSQL.

Database objects: tables and views.

Import/Export | Dump to DDL Data Source

Create your DDL data source by dumping a regular data source to a root/repository folder.

Data sources and their elements.

Import/Export | Export with 'mysqldump'

or

Import/Export | Export with 'pg_dump'

Run mysqldump or pg_dump for the selected items. mysqldump and pg_dump are native MySQL and PostgreSQL tools. They are not integrated into IntelliJ IDEA. You can read about them at dev.mysql.com and postgresql.org.

Data source nodes.

Import/Export | Restore with 'mysql'

or

Import/Export | Restore with 'psql'

or

Restore

Run mysql, pg_restore, or psql to restore a data dump. These tools are native for MySQL and PostgreSQL. They are not integrated into IntelliJ IDEA. You can read about them at dev.mysql.com and postgresql.org.

Data source nodes.

Diagrams | Show Visualisation

and

Diagrams | Show Visualisation Popup

CtrlAltShift0U and CtrlAlt0U

View a UML class diagram for the selected data source or table. You can select between the following options:

• Show Diagram to open the diagram in a separate editor tab.

• Show Diagram Popup to see the diagram in a popup.

Data sources and their elements.

Diagnostics | Dump Metadata Model

(former Dump Metadata Model)

Generate a diagnostic representation of the database in a IntelliJ IDEA internal format. This information might be helpful for the support team if some database objects exist in the database but do not show up in the Database tool window.

Data sources and their elements.

Diagnostics | Generate Introspector Diagnostic Files

(former Generate Introspector Diagnostic Files)

Generate three files that include information about the following:

• dataSource.txt: the data source.

• introspector.txt: a module that was used to load the metadata from the database.

• model.xml: a part of the database model.

This information might be helpful when introspection works incorrectly. For example, when you see something outdated or do not see new objects.

Data sources and their elements.

Diagnostics | Force Refresh

CtrlShiftF5

Delete the data source information from cache and load it again. This action is available on the data source node only.

Data source nodes.

Diagnostics | Forget This Schema Cache

Delete the information that IntelliJ IDEA has accumulated about your database. This action is available on the data source node only.

Use this command when you experience issues like wrong display of data structures or errors during synchronization.

To check if this has eliminated the problem, use the Synchronize command.

Data source nodes.

Diagnostic Mode

Enables the diagnostic mode where IntelliJ IDEA writes the introspection log.

You can access the log file by clicking the link in the Diagnostic log started and Diagnostic log stopped notification popups that appear once you enable and disable the mode.