This is because it may have multiple dependencies in triggers, SP-s, Foreign keys.
You can create new table, do an 'insert into ... select' statement, and that's all. If you want to, you can write an SP which will do this.

----- Original Message -----
From: Bert_Herngreen
To: firebird-support@yahoogroups.com
Sent: Wednesday, December 27, 2006 11:04 AM
Subject: [firebird-support] Renaming tables in Firebird


Hi,

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?

Kind regards,
Bert





[Non-text portions of this message have been removed]