Copy table structure

Is there any way to copy the table structure of a table to a new table.

I was using

Create table Table2 as select * from Table1 where 1=2;

this copied the columns, but all constraints where lost.

I was wondering if anyone knows a way to do this easily.

Thanks

Steve(steve_at_dmtserv.com) Received on Tue Jul 11 2000 - 00:00:00 CEST