--- In firebird-php@yahoogroups.com, Milan Babuskov <albis@e...> wrote:

> 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

Hi Milan!

I´m using PHP and ibWebAdmin. What actually is the SQL code that creates id=
entical
tables? Do I have to create a new table and enter the information about the=
rows
again manually?

Thanks in advance fo your help!

Edi