IntelliJ IDEA
 
Get IntelliJ IDEA
You are viewing the documentation for an earlier version of IntelliJ IDEA.

View data

Last modified: 10 August 2022

When you double-click a table in the Database tool window (View | Tool Windows | Database), the table opens in the data editor. You can browse and edit table data in three modes: Table, Tree, Text, and Transpose. To switch between these modes, click the View as button (the View as button) and select the mode that you need.

  • Table: the default viewing mode of table data. Data in a table is stored in a cell that is an intersection of a vertical column and horizontal row.

    The table viewing mode
  • Tree: viewing mode in which data is displayed in the key-value table with the possibility to expand the key cell if it contains children nodes. Data from the expanded children node is distributed between key and value columns. You might consider using this mode to work with JSON and array data.

    The tree viewing mode
  • Text: viewing mode in which data is displayed as a text.

    The transposed table viewing mode
  • Transpose: viewing mode in which rows and columns are interchanged. You can combine this checkbox with other viewing modes.

    To make this mode a default for tables and views, open settings by pressing Ctrl+Alt+S and navigate to Tools | Database | Data Views and select the Automatically transpose tables. When this option is enabled, query results are not transposed.

    The transposed table viewing mode