File structure

DataGrip allows you to view and navigate the structure of a file in the Structure tool window and the Structure popup.

For a table in a data editor, the Structure tool window shows the list of columns and lets you hide and show the columns, sort the data, and perform other, associated tasks.

To see a reference on possible icons in the Structure tool window, see Data sources and their elements.

You can see the VCS status color hints in the Structure tool window and Structure popup if your project is under version control. It helps you track changes in files. The names of modified objects become blue, and the names of the newly added objects appear in the tool window highlighted in green.

The popup provides less information than the tool window, but it allows you to navigate the structure faster due to the Narrow down on typing option.

Open a file in the editor and in the main menu, go to Navigate | File Structure or press Control+F12.
In the popup, start typing the name of the element that you want to find. You can also use wildcards. The IDE will narrow down the search results as you type.
You can additionally narrow down your search results by using the checkboxes in the popup. To change the sorting, click and select the necessary option.
Press Enter or click an item to close the popup and navigate to the selected element in the editor.

Alphabetically: Sorts elements within a class alphabetically.
Narrow down on typing: Hides irrelevant items as you type. When this option is disabled, the IDE highlights all items that match your search query without hiding irrelevant items.

Structure tool window

Open a file in the editor or select it in the Project tool window.
In the main menu, go to View | Tool Windows | Structure or press Alt+7.
In the tool window, start typing the name of the element that you want to find. You can also use wildcards. The IDE will highlight the search results as you type.
You can additionally narrow down your search results or sort the items in the tool window by using the options located under .

View options

Sort

Alphabetically: Sorts elements within a class alphabetically.

Show

DDL statements: Displays only DDL statements (for example, CREATE, ALTER, DROP, and other statements).
DML statements: Displays only DML statements (for example, SELECT, INSERT, UPDATE, DELETE, and other statements).
Select statements: Displays only SELECT statements.
Other: Displays only statements that do not fall under the previous categories.

Group

Group by type: Group statements by their type (for example, DDL statements, DML statements, SELECT statements, and Other).

Last modified: 08 December 2023