How can I get a reverse engineer version of a table to be able to copy
it and create it in another session? EDB Manager has a Copy table
option, but no way to tell it which session to copy it to, so I presume
it does it in the current session.

Okay, found it, but I think it would be nice to improve. Clicking on
the table shows the SQL to create it in the SQL tab at the bottom. Copy
that to a script in the other session and execute to create. Would be
nice to have this as an option somewhere, like "copy table from..."
perhaps. Perhaps also with the content to come over as well. But it is
possible anyway. Thanks for listening. 8-)

--

Matthew Jones

Matthew


You're going to love this -

1. Open the database you want to copy from
2. Open Tables view
3. New (sql window)
4. Switch to blank sql window
5. Drag'n'drop table desired onto blank sql window. Dialog <<Would you also like to include the SQL for inserting existing rows ?>> - yes if you want to

Without closing anything down

6. Open database you want to copy table to (this can be in the same or a different session)
7. Click back to the sql window
8. Click execute or press F9 - your choice

If you're copying lots of rows sit back and enjoy the view


Roy Lambert

Roy Lambert wrote:

> Matthew
>
>
> You're going to love this -
> [snip]
> If you're copying lots of rows sit back and enjoy the view

Even more power, and even more hidden! It needs to be more visible
somewhere.

--

Matthew Jones

Matthew


>Even more power, and even more hidden! It needs to be more visible
>somewhere.

To be fair the only hidden bit is the drag'n'drop. The other parts simply require turning your brain on, or do as I did and do it accidentally and realise what you've done <vbg>

Roy