Subject Re: table structure duplication
Author certfb
In Flamerobin this is very straightforward, just click on the table's properties and then the DDL link. Open the DDL in the SQL editor and you can change the table name then execute the query.

--- In firebird-support@yahoogroups.com, ik <idokan@...> wrote:
>
> Hello,
>
> 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... */
>
> Thanks
> Ido
>
> LINESIP - Opening the source for communication
> http://www.linesip.com
> http://www.linesip.co.il
>
>
> [Non-text portions of this message have been removed]
>