How to view and edit table and column comments with Toad for Db2

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

Table of Contents:


    In this article I will show you how to view and edit column and table comment in Toad for DB2.

    How to view table and columns comments

    First of all open Explorer from main menu.

    To view all tables columns you need to switch explorer view option by click on Explorer Options and select Treelist. Next expand Schemas -> [your schema name] and click on Tables.

    In the viewer will appear list of tables with some properties. One of the property is Remarks column which contains comment for table.

    Column comments are available if instead clicking on Tables branch you simple click on specific table. In the viewer will appear table details. Columns can be found under Columns tab. Comment for column is in Remarks column.

    In the properties tab you can find table comment too.

    How to edit table and columns comments

    To edit comments, in the explorer window right click on specific table and select Alter Table.

    New window will appear where you can edit table properties. Table comment you can edit in General section by editing Comment property. To edit columns comment go to Columns section.

    Select column which comment you want edit and in the column properties edit Comment field.

    When you finish editing comments to apply changes click on Show Script button which generates SQL script for Db2 database.

    Click Execute. If everything goes alright appropriate statement will show-up.

    0
    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).
    Accept