Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread More options for CREATE TABLE (LIKE...)
Sun, Jun 22 2008 7:33 AMPermanent Link

Heiko Knuettel
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
Sun, Jun 22 2008 8:12 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

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]
Sun, Jun 22 2008 9:53 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Heiko,

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

I've already got it on the list. Smiley 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

Image