Subject Re: [ib-support] rename table in firebird
Author Holger Klemt
> Create a new table of the same structure, and pump the data into it. The

you could use www.ibexpert.com and use the following
command

insert into new_table_name select * from old_table_name


This command automatically creates the new table with
the structure from the old tabel, when it not already exists.

--
IBExpert - The most Expert for InterBase --- http://www.ibexpert.com
HK Software - Holger Klemt - Huntestrasse 15 - D-26135 Oldenburg
Telefon Telefax +49 700 IBEXPERT (42397378) www.h-k.de
Schulungen - Projektunterst´┐Żtzung - Delphi - InterBase - AS/400