williamvdw2004 wrote:

> What is the SQL statment to rename a table in firebird please.

There isn't.

CREATE NEWTABLE
COPY DATE FROM OLD TABLE
DROP OLDTABLE

Any links to the old table will be flagged when it is dropped, but
simply trying to change the name causes problems with triggers and
foreign keys linked to the table, hence the three step process is a lot
safer. Data is protected at all times.

Major structural changes - I create the new database, check it out, and
then pump the data from the working copy. Any problems can be addressed
before making the new copy live, and the old copy is still available
until that time!

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services