IntelliJ IDEA 2020.3 Help

Modify

Modify a table

  1. In the Database tool window, right-click a table and select Modify Table.

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

Modify a table from the data editor

You can modify a table while you edit table data.

  1. Double-click a table to open it in the data editor.

  2. Press Ctrl+F6.

  3. Modify table data.

  4. Click Execute.

  5. Press Ctrl+F5 to reload the page.

    Modify a table from the data editor

Enable read-only mode for a table

To protect a table from accidental modifications in the data editor, you can make the table read-only.

  • To enable read-only mode, click the Click to toggle the read-only attribute icon (The Click to toggle the read-only attribute icon) in the lower-right corner of the editor.

To turn off read-only mode, click the Click to toggle the read-only attribute icon again.

Enable the read-only mode for a table

Show descriptions for databases and tables

  • To enable descriptions for databases and tables, navigate to View | Appearance and select Details in Tree Views.

    To add comments for tables, select a table and press Ctrl+F6. In the Comment text field, add a table description.

    To add comments for a database, open database settings Ctrl+Alt+S and add a database description in the Comment text field.

    Show descriptions for databases and tables
Last modified: 08 March 2021