Boris Herbinière-Sève wrote:

> I'm trying to duplicate an existing table structure using SQL, but
> haven't succeeded yet.
>
> In Oracle, MySQL, ... you can use a request like "CREATE TABLE
> duplicateTable AS SELECT * FROM originalTable"
>
> Is there a similar trick in Firebird ?

No. You'll have to use some admin too, copy/paste DDL and change the
table name.


--
Milan Babuskov
http://www.flamerobin.org