Lester Caine wrote:

>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!
>
>

It would be nice if this were possible. Having to rename a table does
happen...

Jonathan Neve.


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