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!

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

I guess I was wrong about that.

> 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?

I have just tried, and it appears that there isn't any option in
ibWebAdmin that will display the table DDL SQL. So if you want to do it
from ibWebAdmin, you have to enter everything again... Not very good.

If you're on Windows I suggest you use some admin tool to connect to
database directly. Ther you can find table DDL statement and copy/paste
to new sql entry window, alter the table name and execute. For example,
you can do this with IBExpert, Firebird workbench or some other tool...

If you cannot access the server remotely, then perhaps you have shell
access to the database server. You can then issue a command like this:

isql -x /path/to/database.gdb -o ddl.sql

You'll get the entire DDL (for all database objects) in file ddl.sql,
and you can edit it, take only what you need, copy/paste and... same as
the first option.

I have try to work with ibWebAdmin for some time (about 2 months ago),
but it has so many restrictions compared to what other non-web tools
offer. At least on Windows. On linux there aren't many tools, you can
try IBAccess if all else fails.

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