Database tool window

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.

Open the DDL 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).

Modify Object

or

Modify Table

Edit the definition of a table, column, index, primary or a foreign key.

View basic information about the selected element.

To close the documentation popup, press Escape.

Add an item to the Favorites list. You can quickly access those items in the Favorites tool window (View | Tool Windows | Favorites).

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.

If your database stores DDL of the object, retrieve DDL from the database.

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

Generate DDL of the object and paste it to a query console.

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

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

Delete the information that CLion 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.

Generate a CLion-specific representation of the database structure (a database model).

Reload the metadata from the database and generate a LOG file. This information might be helpful for the support team when you think that your introspection is slow.

Generate three files that include information about the data source (dataSource.txt), a module that was used to load the metadata from the database (introspector.txt), and a part of the database model (model.xml).

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

Drop

or

Remove

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

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).

Export with 'mysqldump'

or

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 CLion. You can read about them at dev.mysql.com and postgresql.org.

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

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

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

Restore with 'mysql'

Restore with 'psql'

or

Restore

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 Color Settings. In the Database Color Settings dialog, select the dialog and coloring options. To have the data source color applied for query consoles and grids, select the In console editors and grids checkbox.

Diagrams | Show Visualisation

and

Diagrams | Show Visualisation Popup

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

• Show Visualisation to open the diagram on a separate editor tab.

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

Displays folders for data sources if you created any.

Enabled	Disabled

Displays folders for server and database objects. This setting concerns users, roles, tablespaces, modules, foreign data wrappers and other rarely-used objects.

Enabled	Disabled

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 all databases and schemes even if they are not selected for introspection.

When the Show All Namespaces option is disabled, databases that are not selected for introspection do not appear in the Database tool window (View | Tool Windows | Database).

When the Show All Namespaces option is enabled, databases that are not selected for introspection are displayed in the Database tool window (View | Tool Windows | Database).

If the Group Schema Objects or Group Object Elements options are selected, you can select to show or hide the categories that contain no elements.

The Show Empty Groups option is on:

The Show Empty Groups option is off:

Shows or hides parent nodes only when you do not have other objects on the same level with a parent.

Enabled	Disabled

For Oracle, shows or hides auto-generated objects in the tree. It concerns the following objects:

• Materialized view logs

• The underlying tables for materialized views

• Secondary tables

When this option is off, columns, generally, are unsorted.

When this option is on, the columns are ordered alphabetically.

Column. For more information about column icon combinations, see Possible icon combinations for columns.

Read-only data sources

Automatically sets the focus on the object name in the Project view when the editor area is in focus.

Hide the tool window.

To hide all the tool windows, press Ctrl+Shift+F12.