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]