Subject | RE: [firebird-support] COMMENT statement question |
---|---|
Author | Leyne, Sean |
Post date | 2009-06-06T21:43:47Z |
Robert,
If you update the system tables directly you accomplish your goal:
UPDATE RDB$RELATIONS SET
RDB$DESCRIPTION = :MyComment
WHERE
UPPER( RDB$RELATION_Name) = 'MYTABLE'
Sean
> Firebird 2.1 introduced the COMMENT statement for setting metadataCOMMENT
> description. How do I add a multi line comment to an object using
> (without altering the system tables directly)?Curious... why multi-line?
If you update the system tables directly you accomplish your goal:
UPDATE RDB$RELATIONS SET
RDB$DESCRIPTION = :MyComment
WHERE
UPPER( RDB$RELATION_Name) = 'MYTABLE'
Sean