Hi,

can anybody tell me if it is possible to "borrow" a table structure in the
Elevate DB Manager, like we use to in DBISAM ? when creating a new table.
And if so, how I can do this.

Cheers,
Paul

Paul,

this feature is on the list afaik.
Meanwhile you can ReverseEngineer the database and copy the part with
the table you need.

Regards Uli

Paul,

<< can anybody tell me if it is possible to "borrow" a table structure in
the Elevate DB Manager, like we use to in DBISAM ? when creating a new
table. And if so, how I can do this. >>

You can do it quickly via SQL:

CREATE TABLE MyNewTable
(
LIKE MyOtherTable,
LIKE MyOtherOtherTable,
etc.
)

See here:

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=10&topic=148

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> LIKE MyOtherTable,
> LIKE MyOtherOtherTable,

Is this new? I have never seen it.

Uli

Tim

>CREATE TABLE MyNewTable
>(
>LIKE MyOtherTable,
>LIKE MyOtherOtherTable,
>etc.
>)

Does this now take all the constraints, indices and triggers across?

Roy Lambert

Roy,

<< Does this now take all the constraints, indices and triggers across? >>

No, not yet.

--
Tim Young
Elevate Software
www.elevatesoft.com

Uli,

<< Is this new? I have never seen it. >>

No, it's been in there since the beginning, or close to it.

--
Tim Young
Elevate Software
www.elevatesoft.com