Subject | Re: [firebird-support] FB 3 add description to table/ column |
---|---|
Author | Martijn Tonies (Upscene Productions) |
Post date | 2017-04-03T08:02Z |
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
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