[Stuart Schmukler]

Why are MyEclipseIDE DB Browser Tables seperated by schema?

I have some tables in a database that happen to have been creted by different users, so their schemas are different. The problem is that the DB Browser displays the tables seperated by schema and the UML tools will only generate diagrams for tables in the same schema.The problem in DB Browser

There should be way to control the use of schema to seperate tables. I need this to enable me to create diagrams of the whole DB.

Note: the Server Studio product does not seperate tables via schema. The

Could there be a switch to turn off the generation of nodes for the schema?

BTW, I think they all have the same access rights.

Here is the output of TableTest (posted on another DB Explorer thread):
There is a version of this note (with images) on my blog at http://sasconsul.net/blog/?p=4

[b]table_cat     table_schem     table_name     table_type[/b]
xxxxintl     dharrelson     gmps_app_languages     TABLE
xxxxintl     dharrelson     gmps_cat_languages     TABLE
xxxxintl     dharrelson     gmps_faqs     TABLE
xxxxintl     dharrelson     gmps_languages     TABLE
xxxxintl     informix     gmps_content     TABLE
xxxxintl     informix     gmps_highlights     TABLE
xxxxintl     informix     gmps_subscription     TABLE
xxxxintl     informix     gmps_subscription_fields     TABLE
xxxxintl     informix     gmps_subscription_form     TABLE
xxxxintl     informix     ped_approval_sub     TABLE
xxxxintl     xxxx     gmps_apps     TABLE
xxxxintl     xxxx     gmps_catapps     TABLE
xxxxintl     xxxx     gmps_categories     TABLE
xxxxintl     xxxx     gmps_cattypes     TABLE
xxxxintl     xxxx     gmps_features     TABLE
xxxxintl     xxxx     gmps_groupapps     TABLE
xxxxintl     xxxx     gmps_groups     TABLE
xxxxintl     xxxx     gmps_offercats     TABLE
xxxxintl     xxxx     gmps_offers     TABLE
xxxxintl     xxxx     gmps_priorities     TABLE
xxxxintl     xxxx     gmps_reports     TABLE
xxxxintl     xxxx     gmps_reptypes     TABLE
xxxxintl     xxxx     gmps_users     TABLE
xxxxintl     xxxx     gmps_wrappers     TABLE
xxxxintl     xxxx     ped_approval_list     TABLE
xxxxintl     xxxx     ped_approval_mfg     TABLE

[Riyad Kalla]

This could certainly be added as an enhancement request.

But I believe you mean the ER Designer and not the UML tool above, as the UML tool has no integration with the DB tools at this time.

[Stuart Schmukler]

Your right. ER Designer is the tool. I would love to see some integration between the UML and the DB.

Stuart

[Author]

Posts