In this article I will show you how to edit column and table description in Toad for SQL Server.
Open Object Explorer by Tool -> Explorer or click on the Explorer icon in menu.
In the new opened window:
To edit table comment switch to Columns option. In column list choose column then change value of the Description field.
This option is useful when you want to find all tables which contain specific column name (i.e. ‘FirstName’) and describe them.
Open Find tool which you can find as icon in main menu (under Tools -> Find or just by pressing F4 key.)
In new opened window (Object Search):
Now you can, like in previous option, edit table and column description by right click -> MS_Description or Alter Table.