Hi,

Did you only try to add a column heading,
i.e. LABEL ON YourSchema/YourTable COLUMN(YourColumn IS 'Whatever Text')?

Or did you also try to add a text,
i.e. LABEL ON YourSchema/YourTable COLUMN(YourColumn TEXT IS 'Whatever
Text')?

May be they cannot see the column heading but the text in their DB Tools. In
this way long comments could be avoided.

BTW I use all, i.e LABEL ON for a short descriptions (Text and Column
Headings) and COMMENT ON if I need a more detailed explanation for the
database object.


Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Gqcy
Gesendet: Friday, 24. June 2011 22:32
An: midrange-l@xxxxxxxxxxxx
Betreff: SQL TABLES: COMMENT vs. LABEL

The windows group has just asked me if I could also generate the same
Field values in the LABEL construct as a COMMENT construct, as they
can't see the LABEL in their DB tools.
Does anyone do both? Pros? Cons?

thanks




This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].