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.
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.
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.
With DataGrip you can always see your tables and their relationships in an insightful diagram, available by pressing Ctrl+Alt+U or from the context menu of the objects you want to visualize. The column with primary and foreign keys can be hidden from the diagram and be shown only on relation lines. These diagrams may be exported to image files when necessary.