Subject Re: [firebird-support] Rename table
Author Sándor Tamás
Not to stick this topic strictly:
Is there any possibility, that I have created view on a table with some 'where' condition, and it slows SPs so much, with the original table, and where clauese I get some 10 secs, but with view, with the same clauses (of course without the table filtering) I got 2-3 minutes, or maybe 10-20 minutes. Can I do aníthing with this?
----- Original Message -----
From: Lester Caine
Sent: Tuesday, August 23, 2005 10:35 AM
Subject: Re: [firebird-support] Rename table

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):
>>>>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


Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links

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