create table table2 (
like table1
INCLUDING IDENTITY
INCLUDING DEFAULTS
INCLUDING GENERATED
)

An additional INCLUDING CONSTRAINTS and INCLUDING INDICES would be nice.

Or is there another possibility to get an 1:1 copy of the table without data ?

Heiko

Heiko


I'm not aware of anything else. Short term you could always interrogate the system tables yourself to build the missing bits.

Roy Lambert [Team Elevate]

Heiko,

<< An additional INCLUDING CONSTRAINTS and INCLUDING INDICES would be nice.
>>

I've already got it on the list.  I'm going to try to get the list of
things I'm working on up on the web site either today or tomorrow so
everyone can check the list to see what enhancements are present.

--
Tim Young
Elevate Software
www.elevatesoft.com