Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Duplicate Table with indexes ?
Sat, Jul 19 2008 8:18 AMPermanent Link

Charalabos Michael
Hello,
  Is there any way to duplicate a table with indexes ?

Thank you
--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr
Sat, Jul 19 2008 9:55 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Charalabos


Its supposed to be part of the CREATE TABLE LIKE .... INCLUDING ... stuff, but its doesn't seem to be there yet (at least not in the manual).

All I can suggest at this point is a script, read the Indexes Table & the IndexColumns Table and roll your own.

Roy Lambert [Team Elevate]
Sat, Jul 19 2008 1:35 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Its supposed to be part of the CREATE TABLE LIKE .... INCLUDING ...
stuff, but its doesn't seem to be there yet (at least not in the manual). >>

No it's not done yet, but it's still on the list.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, Jul 19 2008 8:07 PMPermanent Link

Charalabos Michael
Hello Tim, Roy,

> Roy,
>
> << Its supposed to be part of the CREATE TABLE LIKE .... INCLUDING ...
> stuff, but its doesn't seem to be there yet (at least not in the manual). >>
>
> No it's not done yet, but it's still on the list.

That's why i could find it! Smiley

IOW, in dbisam there was a "Borrow Structure".
In EDB there is "NOTHING". Frown

It starts to remind me the DBISAM v2 days when the child was
growing ... Smiley

Tim, could you please raise it's priority ?
(Anyhow, i think that it shouldn't be hard to add index support
 in "create table as")

Thank you
--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr
Mon, Jul 21 2008 2:25 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< Tim, could you please raise it's priority ? >>

As already indicated, it's on the list for 2.0.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image