In ddl.txt wrote
.......
4) Allow comments in database objects.
(Claudio Valderrama C.)
Proposed syntax for testing:
COMMENT ON DATABASE IS {'txt'|NULL};
COMMENT ON <basic_type> name IS {'txt'|NULL};
COMMENT ON COLUMN table_or_view_name.field_name IS {'txt'|NULL};
COMMENT ON {PROCEDURE | FUNCTION} [<package_name> .] name.param_name IS
{'txt'|NULL};
COMMENT ON [PROCEDURE | FUNCTION] PARAMETER [<package_name> .]
name.param_name IS {'txt'|NULL};
An empty literal string '' will act as NULL since the internal code (DYN
in this case)
works this way with blobs.
basic_type:
- DOMAIN
- TABLE
- VIEW
- PROCEDURE
- TRIGGER
- EXTERNAL FUNCTION
- FILTER
- EXCEPTION
- GENERATOR
- SEQUENCE
- INDEX
- ROLE
- CHARACTER SET
- COLLATION
- USER (ability to store comment depends upon user management plugin)
- SECURITY CLASS (not implemented because Borland hid them).
...
In base_type lacks PACKAGE. And what about the EXTERNAL FUNCTION, because
now the function can not only be external. I tried to comment PSQL
function. Permitted to use or not to use the EXTERNAL
comment on external function MyFunc is 'PSQL function';
comment on function MyFunc is 'PSQL function';
Maybe base_type write something like [EXTERNAL] FUNCTION
--
Simonov Denis
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
