Subject | COMMENT statement question |
---|---|
Author | rj1102 |
Post date | 2009-06-06T21:19:14Z |
Hi all!,
Firebird 2.1 introduced the COMMENT statement for setting metadata description. How do I add a multi line comment to an object using COMMENT (without altering the system tables directly)?
E.g. this does not work (parameter seems to be not allowed):
COMMENT ON MyTable IS :MyComment
This does also not work (expressions seem to be not allowed):
COMMENT ON MyTable IS 'line 1' || ASCII_CHAR(13) || 'line 2'
Thanks,
Robert
Firebird 2.1 introduced the COMMENT statement for setting metadata description. How do I add a multi line comment to an object using COMMENT (without altering the system tables directly)?
E.g. this does not work (parameter seems to be not allowed):
COMMENT ON MyTable IS :MyComment
This does also not work (expressions seem to be not allowed):
COMMENT ON MyTable IS 'line 1' || ASCII_CHAR(13) || 'line 2'
Thanks,
Robert