How to create ER diagram for existing database with Toad for Oracle

This tutorial will show you how to generate ER Diagram and save it as image in Toad for Oracle. After connect to your database:

  1. choose on toolbar Database -> Report -> ER Diagram.

  1. In ER Diagram window click add object button (1) and select objects you want to add to the ER diagram (2). Next click ok button to create ER diagram.

  2. If you want to save the ER diagram, you can do this through:

    • using File -> Save As option. This option allows saves diagram as .erx format, which allows you to open it and modify later in Toad
    • copying diagram to clipboard - You can do it by selecting all objects in diagram and than pressing CTRL+C combination or by using Copy Image To Clipboard (button 1)
    • export diagram to multiple graphical formats. After clicking on Export to Graphical File (button 2)