Subject Re: [firebird-support] FB 3 add description to table/ column
Author Martijn Tonies (Upscene Productions)
Hello Michał,

Firebird 3 uses the following syntax:
COMMENT ON <objecttype> <name> IS 'value'
COMMENT ON COLUMN <table_name>.<column_name> IS 'value'


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.


-----Original Message-----

Code from fb 2.5 does not work:

update rdb$relation_fields set rdb$description = 'aaa'
where rdb$field_name = 'new_name" and rdb$relation_name = 'table_name'

Update operation is not allowed for system table rdb$ralation_fields

FB 3.0.2.32692

--
pozdr,
Michał Kurczabiński