Re: [firebird-support] FB 3 add description to table/ column

2017-04-03 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hello Michał, Firebird 3 uses the following syntax: COMMENT ON IS 'value' COMMENT ON COLUMN . 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

[firebird-support] FB 3 add description to table/ column

2017-04-03 Thread Michal Kurczabinski michk...@gmail.com [firebird-support]
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