Subject RE: [firebird-support] Rename table
Author David Johnson
On Tue, 2005-08-23 at 10:24 +0200, Bc. Jiri Cincura wrote:
> Martijn Tonies wrote (on Tuesday, August 23, 2005 9:57 AM):
> >> Bc. Jiri Cincura wrote (on Monday, August 22, 2005 7:47 PM):
> >>> Hi,
> >>>
> >>> 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.

There is no such thing as too big, unless you have a huge system.
Storage is is cheap now - a terabyte of commodity storage can be had for
under $1,000. RAID costs proportionately more, but is still relatively
cheap.

>
> So it must stay as is.
>

Your choice.