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 and use the following

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 ---
HK Software - Holger Klemt - Huntestrasse 15 - D-26135 Oldenburg
Telefon Telefax +49 700 IBEXPERT (42397378)
Schulungen - Projektunterst´┐Żtzung - Delphi - InterBase - AS/400