Columns

1. In the Database tool window ( View | Tool Windows | Database) , expand the data source tree until the nodes of tables.

2. Right-click the table node and select New | Column.

3. In the Modify dialog that opens, enter the name of your column in the Name field.

4. In the Preview pane, you can view and change the generated SQL code.

5. Click OK to add your column.

1. Right-click a column and select Drop. Alternatively, press Delete.

2. Click OK.

For more information about the dialog options, refer to Confirm Drop dialog.

Starting with IntelliJ IDEA 2022.1, you can change database-specific parameters of a column. The IDE generates fields for the Modify dialog automatically according to the properties received during the introspection. For example, by using this dialog in PostgreSQL, you can add and edit column check constraints.

1. In the Database tool window ( View | Tool Windows | Database) , right-click a column and select Modify Column.

2. In the Modify dialog, specify object settings that you need.

   note

   Column settings depend on the database vendor. For example, the Auto Increment checkbox is only available for SQLite, MySQL, and other vendors that allow it for a primary key column of an integer data type.

3. Click OK save your changes.

• To reorder columns, drag the corresponding cells in the header row.

• To hide a column, right-click the corresponding header cell and select Hide column.

  Alternatively, you can right-click any of the cells in the header row and select Columns List CtrlF12. In the Columns List window, select a column name and press Space. You can hide all columns. To search through the column list, just start typing a column name in the Columns List window.

  

1. Right-click any of the cells in the header row and select Columns List. Alternatively, press CtrlF12.

2. Select the hidden column (a strikethrough column name) and press Space.

   

• Click the settings icon () and select Reset View. As a result, the data becomes unsorted, the columns appear in the order they were defined initially, and all the columns are shown.

  

• You can assign HTML, CSS, XML, RegExp, or any other formal language for the whole column. So, when you have a piece of code inside the cell that belongs to the column, you can use code generation, code completion, and other IDE features.

  To inject a language for the whole column, right-click the corresponding header cell, and select Set Highlighting Language. In the list of supported languages, select the language that you want to inject.

  

• Place the caret between two columns, so it changes to the resize mode. Drag it to the preferred position.