automatically ER Diagram create in TOAD ORACLE

Posted on 2006-04-07
Last Modified: 2016-09-26
How to see relationship  table in Oracle using TOAD,
because i must to see relationship  to make view of  tables..
because not me build the database and make tables,
but I have job to make report using crystal report, so for easy way I want to using view...
but i don't know from which i use data in where table because this report is involved many table.
so for easy way i have idea to see ER diagram but i dispointed because empty...
is another else to see ER Diagram is automatically build, so i have see ER DIagram to see relationship betwen many tables in database???

Thanks for helping me....

Question by:qball2525
    LVL 19

    Expert Comment

    Do you have ERWin? it can build diagrams for you which contains relationship for you as well.

    LVL 2

    Accepted Solution

    Tools -> ER Diagram

    To create a New Diagram

    1. From the toolbar, select the New Diagram button. The Create ER Diagram dialog appears.

    2. Enter the Schema where your table resides from the drop down schema menu.

    3. Enter the Table you want to diagram.

    4. Select the number of levels of referential tables you want to load.

    Note: The more levels of referential tables you load, the more complicated the diagram will become, and the longer TOAD will take to create the diagram.

    5. Select your display options. You can:
    Show primary keys
    Show foreign keys
    Show unique keys
    Show data type
    Show not nullable
    Show indexes

    6. Click OK to generate the diagram.


    Author Comment

    Sorry took for long response...
    by the way where is button ok i did'nt see...

    Expert Comment

    by:G Krishna Rao
    Where is Tools option in toad.l  i couldn't  see..

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now