Toad World® Forums

Enhancement on the Entity Properties about Comment field


#1

Hi

I am wondering if it is possible to make the comment field editable on the “Entity properties” windows? I tried to press F2 and click on the field twice, but it does not allow me to edit it. I can only edit that field on “Attribute properties” window under the Description tab.

Please let me know if you want me to explain more.

Many thanks

Chi


#2

Hello Chi,

You’re right. It is not possible to edit the attribute comments in the Entity Properties form. Comments are usually long, on more lines. In the Comments column, you can see only beginning of the comment. It informs you that there is a comment at particular attribute. This is all.
If you like to edit it, you will have to edit the attribute. I’m sorry.

Regards,

Vladka


#3

Hi Vladka

Maybe you are right that the comments are usually long.
I am wondering if it is possible to export the comment on the SQL script as well?
So that the end user could be able to see what is the purpose of that field? Instead of having the need of generate the Report?

Many thanks

Chi


#4

Hello Chi,

Comments/descriptions are generated in SQL script.
(Comments (e.g. Oracle db), Descriptions (MS SQL Server db).)

In the DDL Script Generation dialog | Detail Settings tab, the checkbox ‘Create Comments’ or ‘Create Descriptions’ must be selected.

Important information on MS SQL Server db - Besides the condition above, the following stands for this database (let me quote the Help file):

To generate the table, column descriptions for SQL Server db in Toad Data Modeler, schema/owner has to be defined.
Please see the Entity Properties form | General tab and from the Schema box select a schema or click the icon on the right to open the Schema dialog and define a new schema, then select it for the entity.

Please let me know if it works fine for you. Thanks.

Regards,

Vladka