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

Tables

Last modified: 11 October 2024

A database table is a structure that organizes data into rows and columns. Data in a table is stored in a cell that is an intersection of a vertical column and horizontal row. The table has a specified number of columns, but can have any number of rows. With IntelliJ IDEA, you can perform data manipulation and data definition operations with tables.

In IntelliJ IDEA, you can work with a table in data editor. When you double-click a table in the Database tool window ( View | Tool Windows | Database) , the table is opened in the Table viewing mode of data editor.

Tables ( Table) can be found in the Database tool window. For the reference on other node and object icons, refer to the Data sources and their elements chapter of Database tool window topic. For the table column icons, refer to the Possible icon combinations for columns chapter.

Tables in Database

In IntelliJ IDEA, each table opens in a separate tab. The following rules are applied to long tab titles:

  • The Always show qualified names for database objects option is now turned off by default. Tab names for objects are qualified if you open two tabs of objects with the same name. For example, if you open two actor tables from different schemas, the schema name is added in the tab name.

  • If the data source has a name that is longer than 20 symbols, the name is truncated.

  • If you have only one data source, IntelliJ IDEA does not display the data source name in the tab name.

  • If a qualified object name has more than 36 symbols, it is truncated.

Working with tables