> I'm looking for a way to duplicate table structure to a new table.
>
> I found that PostgreSQL support such thing, and I wonder if FB also have any
> syntax for it.
>
> The PostgreSQL syntax is like so:
>
> CREATE TABLE table2 (LIKE table1);
>
> CREATE TABLE table3 (LIKE table1 INCLUDING ALL); /* Include index,
> constrains, comments etc... */

Currently there is no DDL out-of-the box way, but basically all serious
third-party tools allow to do that.

For DDL support, you could vote for this one here:
http://tracker.firebirdsql.org/browse/CORE-796



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!