Toad World® Forums

Any way to filter on a table(s) and all tables that directly join to ?


#1

I’m in the process of re-engineering the model of a large database and would like to be able to select a table or set of tables and display them and any tables that directly joins to them.

Inmya workspace this would ideally temporarily hide all the non selected tables from the view.

Message was edited by: bill_484


#2

Hello,

TDM allows you to select a table or set of tables. You can select tables from different schemas, multiple filtering is available (in latest Beta and upcoming full v. 3.5).
However, TDM cannot display tables that directly join to the selected tables.

We recommend you to check out Toad for Oracle - this feature should be available in ER Diagrammer (or via Schema Browser and Description Window).

Feel free to ask for current Toad for Oracle trial version or Beta (trial or full key is required for Beta). Latest Beta has brought some enhancements of this functionality.
So, let me redirect you to the Toad for Oracle community:
http://toadfororacle.com/index.jspa

Note: TDM and Toad are integrated. You can RE your tables to Toad. Then import Toad ERD to TDM and work with it in TDM.
http://modeling.inside.quest.com/entry.jspa?externalID=1684&categoryID=158

Regards,

Vladka + TDM Team