| Subject | How can one rename a table in Firebird 3.0 |
|---|---|
| Author | |
| Post date | 2017-07-12T16:13:58Z |
In Firebird 2.5 and earlier one could rename a table by the following query:
UPDATE RDB$RELATIONS SET RDB$RELATION_NAME='NEW_NAME'
where RDB$RELATION_NAME='OLD_NAME';
UPDATE RDB$RELATIONS SET RDB$RELATION_NAME='NEW_NAME'
where RDB$RELATION_NAME='OLD_NAME';
But this query throws an error (unknown ISC error 335545030) in Firebird 3.0. So my question is does someone know a method in Firebird 3.0.
With kind regards,
Roy