This option lets you control general appearance and behavior of the tool window. For more information about query consoles, refer to Query console reference.ĭisplay the toolbar in the Database Explorer. The feature is currently not supported for ClickHouse, Redis, Apache Cassandra, and Apache Hive.Īutomatically set the focus on the object name in the Database Explorer when you select that object tab in the editor.ĭisplay the toolbar in the query console tabs. When the option is disabled, natural sort order is applied.ĭisplay the local date and time of the last performed introspection for schemas. To see the columns just under the table node. To find an object inside a schema with the help of a quick search. You can use this option in the following situations: For example, nodes for keys, CHECK constraints, indexes, triggers, rules, and other objects. Place Constraints and Similar Objects under Schemaĭisplay nodes for object names that exist in a schema namespace. In Microsoft SQL Server, Oracle, and PostgreSQL, separates procedures and functions into different folders. The underlying tables for materialized views Shows or hides parent nodes only when you do not have other objects on the same level with a parent.įor Oracle, shows or hides auto-generated objects in the tree. If the Schema Objects or Object Elements options are selected, you can select to show or hide the categories that contain no elements. When the All Namespaces option is enabled, databases that are not selected for introspection are displayed in the Database Explorer. When the All Namespaces option is disabled, databases that are not selected for introspection do not appear in the Database Explorer. Show all databases and schemes even if they are not selected for introspection. When off, there is no such grouping and, generally, only columns are shown for tables. The elements appear in the corresponding groups. When on, there are separate nodes for columns, indexes, primary and foreign key constraints, and triggers (shown as folders). This option defines how table elements are shown. Tables and views are followed by procedures and functions. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |