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?
Ann W. Harrison answers:
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.