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.