MyEclipse :: View topic - How to modify table once the wizard is closed?

MyEclipse: How to modify table once the wizard is closed?

Durnik - Nov 29, 2011 - 04:23 PM
Post subject: How to modify table once the wizard is closed?

To all,

With myeclipse 10.0, after you've used the table wizard to generate an initial table structure, is there anyway to pull up a similar wizard to modify the table (e.g. add rows, etc)?

Using DB explorer I can edit the data in a table, but it looks like the only way to modify the table post wizard is to drop into SQL and modify it directly.

Is this correct or am I missing something?

support-swapna - Nov 30, 2011 - 05:09 AM
Post subject:

Durnik ,

I am afraid there is no other way apart from the Edit Data and using SQL queries to modify the table.
Sorry for the inconvenience caused.

Durnik - Nov 30, 2011 - 06:38 PM
Post subject:

Swapna,

Thanks for the reply. Is there an enhancement request that could be opened for such a feature? It just seems silly that the wizard provides an easy method to generate the initial table, but I can't imagine that everyone gets the table correct in the first pass.

Having to then drop down into raw SQL to modify your table structure seems like a glaring omission to me.

Durnik

support-tony - Dec 01, 2011 - 08:49 AM
Post subject:

Durnik,

I've raised an enhancement request for this, though I can't say when it's likely to be implemented. I agree that it would be a useful enhancement and I assume that you meant "add columns", in your first post, not "add rows".

Durnik - Dec 06, 2011 - 03:13 PM
Post subject:

support-tony wrote:

Tony,

You're correct. The ability to modify the table structure (add, delete, change columns) using a wizard like interface to minimize the need to edit the table structure using raw sql.

Durnik

mongonv - Dec 25, 2011 - 06:55 PM
Post subject:

In looking thru the forums, modifying tables and adding new records to a table have been requested by users since at least version 6.

Without those two items, the database explorer is pretty worthless and pushes us developers to use other tools that are able to do basic table management operations without having to resort to writing SQL commands to do things.

It is silly that in three plus years your team has not added two basic database management features that are used on a VERY regular basis by almost any developer.