When off, there is no explicit grouping for tables, views, and routines. Tables, views and routines (procedures and functions) are shown as elements of the corresponding groups. When on, there are separate nodes for tables, views and stored routines (shown as folders). This setting concerns users, roles, tablespaces, modules, foreign data wrappers and other rarely-used objects. For more information about the New UI, refer to the corresponding topic.ĭisplays folders for data sources if you created any.įor more information about creating folders, refer to the Group data sources in folders chapter.ĭisplays folders for databases and schemas.ĭisplays folders for server and database objects, Server Objects and Database Objects correspondingly. Starting from version 2023.1, the New UI is available. In the video, the DataGrip user interface is Classic UI. The following video presents a short overview of the Database Explorer tool window. If the toolbar is not currently shown, click the Options button ( ) on the title bar and select Show Toolbar. If the toolbar is hidden, the Refresh and Open Query Console commands can be access by means of the title bar buttons ( and respectively). Many of the commands have keyboard shortcuts. Most of the functions in this window are accessed by using the toolbar icons or context menu commands.

For more information about working with database objects in DataGrip, refer to the Database objects section. For more information about the objects viewing options, refer to the View options chapter. Once DataGrip is connected to a database, Database Explorer will display the introspected database objects. For more information about data sources, refer to the Data sources topic. If no data sources are currently defined, use the New command Alt+Insert to create a data source and connect to a database. The available data sources are shown as a tree of data sources, schemas, tables and columns. You can view and modify data structures in your databases, and perform other associated tasks. In the Database Explorer ( View | Tool Windows | Database Explorer), you can work with databases and DDL data sources.

Jetbrains datagrip stored procedures