Subject Re: [firebird-support] Rename table
Author Martijn Tonies
> >>> is there any option how to rename table?
> >>
> >> Nobody knows? :\
> >
> > Sure, the only thing you can do is extract the DDL, rename the table
> > and recreate the table. Next, pump the data.
> >
> > There's no built-in "rename" functionality.
> It's not good. :( The table is about too big to do this.
> So it must stay as is.

In some cases, the following solution might help:

create view mynewname as select * from myoldtable


This is what we did when someone finally discovered a typo in a legacy
table name already in use all over the bloody application! The guy who
created the table and continued using it with the typo included was,
obviously, smacked in the head :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!