At 03/04/2002 01:56 PM, you wrote:

>At 06:55 AM 4/3/2002 +0000, mircostange wrote:
>
> >Why does Firebird not support a COMMENT clause in CREATE TABLE?
>
>Because InterBase SQL didn't. InterBase SQL didn't because it
>wasn't standard. This would be an easy feature (give or take
>comment end indicators) but more useful if the tools let you
>see the comments.

Hi,

QuickDesk and IB Expert do let you view/edit the description field. I
don't know about the other tools though, I think some others do. I find
this capability useful for documenting, since I can printout the database
structure including the description fields. And, it would be nice to be
able to do it through SQL statements and to be able to retrieve them via
SQL statements for usage in an application, instead of using the system
tables. This is probably one of those "if you build it, people will use
it" kind of thing.

Just my 2 cents.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)