Subject Re: [ib-support] rename table in firebird
Author Helen Borrie
At 11:04 AM 24-06-02 +0800, you wrote:
>can anybody advice how to rename an existing table? i have tried few tools:
>IBExpert, IBAccess and Marathon but could not find a way to rename a table.
>please help, thanks in advance.

Create a new table of the same structure, and pump the data into it. The
IB_SQL tool from has a good datapump utility.

Basically, renaming objects is not an operation you can do with standard
SQL. The reason, of course, is that the metadata are keyed on the object
names and there are dependencies (obvious and less obvious) which could
break. A very experienced developer might attempt to update the system
objects directly but, more than likely, she would not, preferring to take
the safer, correct route.


All for Open and Open for All
Firebird Open SQL Database · ·