Database objects

Introspection

Database view window contains all your data sources and their schemas with tables, functions, and views, etc. divided into folders which can be collapsed and expanded.

Choose schemas to introspect

Select only the current schema or those you need for your work.

Filter schemas

In data source properties there is the Pattern field where you can describe what schemas you want to see in the database tree. The Ctrl+Q shortcut will give you information about the syntax.

Group data sources

Group data sources by type, for instance database vendor. Press F6 or choose Move to group… from the context menu.

Copy data sources

It frequently happens, that you want to use the same data sources in another project or even the other IntelliJ-based IDE. Select the data sources you want to share and then go to the context menu → Database Tools → Copy Settings.

Paste data sources

To paste the data source press + and then Import from clipboard. In your clipboard you have just an XML, so you can even send it via messenger.

Create/modify table

The IDE provides a unified UI for adding or editing tables and table components: columns, indexes and constraints. This window has all the controls you need to define all of these components. Note that if Execute in database is enabled, all your changes will be immediately applied to the database.

Press Ctrl+F6 on the table name in either the database tree or the SQL-script to modify them. The Create/Modify Table window also has an instant preview to help you work with database objects and generate code effectively. To learn more about creating and modifying objects, please see code generation.

To edit data in the table, press F4. See data editor.

Edit source code

Invoke the Edit action for any database object by pressing Ctrl+B and get a DDL statement for procedures and functions.

DataGrip keeps the source code of database objects in local storage. It means that you can see the parts of the source code you've changed and it's able to revert any change back to the server version.

Additionally, the source code storage lets you search for particular pieces of code through the entire source code of your database.