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

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


Michał Kurczabiński