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


Reply via email to