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
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
Mit freundlichen Grüßen / Best regards
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
"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!"
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Gqcy
Gesendet: Friday, 24. June 2011 22:32
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?
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