Subject Re: [firebird-php] copying a table
Author Milan Babuskov
edi_kolb wrote:
> I´m quite new to Firebird and am using it (unwillingly) for our
> website. I am looking
> for a method to copy an existing table. It doesn´t matter wether
> data is copied or not
> but at least the structure should be the same. Plz give me a SQL code
> that does the
> trick!

Which tool are you using to access the database?

For example, with isql, you could see the table DDL with SHOW TABLE
command or -x parameter, and then write the SQL that creates identical
tables.

To fill the new table use:
INSERT INTO newtable
SELECT * FROM oldtable;

If you're only using PHP, you should install ibWebAdmin and you can
easily to the same thing from it.

--
Milan Babuskov
http://fbexport.sourceforge.net