How to view and edit table and column comments with JetBrains DataGrip

Bart Gawrych - Dataedo Team Bart Gawrych 2019-09-17

Table of Contents:

    This tutorial will show you how to view and edit table and column descriptions using DataGrip tool.

    Firstable, find in toolbar View -> Tool Windows -> Database or press Alt + 1 key combination.

    Fig. 1. Database option in toolbar

    In opened explorer expand your database, schema and table branch. To see and edit table comment right click on table and choose Database Tools -> Modify Comment

    Fig. 2. Modify table comment in table context menu

    Editing column comment is done in the same way. Right click on column name and select Database Tools -> Modify Comment. In general you can edit comment of almost every object in explorer in the same way.

    Fig. 3. Modify column comment in column context menu

    After clicking on Modify Comment option (in both cases), new window will pop-up where you can edit comment. Click OK to persist changes to database.

    Fig. 4. Modify comment window

    Editing comments can be done also by Modify Table option in table context menu (right click).

    Fig. 5. Modify Table in table context menu

    In Modify Table window you can find editable field with table comment next to table name. To edit column comment switch to Columns tab and double click on column which comment you want edit. Column will expand and new options will appear. Click on comment icon on the right side of window.

    Fig. 6. Modify table window

    Like in previous method, similar pop-up window will appear where you can edit column comment, but this time OK button doesn’t commit changes to database.

    Fig. 7. Edit column comment window

    In order to accept all changes and save it in database click Execute button in Modify Table window.

    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).