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

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.

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.