Subject Re: [firebird-support] Renaming tables in Firebird
Author Ann W. Harrison
Bert_Herngreen wrote:
> What is the reason that renaming tables in Firebird is not possible by
> a (single) statement like 'ALTER TABLE X RENAME TO Y'. Does it have a
> technical reason and would it be hard to implement in the engine?

The reason it wasn't done originally is that table names can be used
in lots of metadata objects - views, procedures, triggers, computed
fields, constraints, etc. The references, in all cases, are to the
table name. However, column names can be used in all those places,
and column names can be changed. If I recall correctly, it took a
long time to implement the column name change and longer to get it
working correctly in all cases. So the answer is yes, it would be
quite a lot of work.