Subject Copy paste tables
Author throwmail2000
What's the easy way to copy table(without data)?

I tried 'insert into mytable2 select * from mytable1 where 1=0;

This did created mytable2 table, but it didn't copied the damin names
and instead put the firebird native data type as field types.
I ran the above query in IBExpert.

Also when I looked into DDL there were no Trigger or generator
for mytable2, mytable1 has one trigger and 1 generator.

Thanks