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.
>
> So it must stay as is.

Why do you need to change the name ?
How about just adding a view with the new name ?

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