According to SQL92 specifications ...

create newtable as
select * from oldtable;

drop oldtable;

But this doesn't seem to work in Firebird. A review of the Interbase
documentation suggests that there is no direct method. You will need to
create your new table, migrate your data, and then drop the old table.

On Tue, 2005-08-23 at 09:01 +0200, Bc. Jiri Cincura wrote:
> Bc. Jiri Cincura wrote (on Monday, August 22, 2005 7:47 PM):
> > Hi,
> >
> > is there any option how to rename table?
>
> Nobody knows? :\
>