# Importing relations for ER Diagrammer

**URL:** <https://forums.toadworld.com/t/importing-relations-for-er-diagrammer/5768>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [September 17, 2007, 7:44am UTC](https://forums.toadworld.com/t/importing-relations-for-er-diagrammer/5768 "2007-09-17T07:44:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wmarkus](https://avatars.discourse-cdn.com/v4/letter/w/43a26b/32.png) [@wmarkus](https://forums.toadworld.com/u/wmarkus)\
**Post date:** [September 17, 2007, 7:44am UTC](https://forums.toadworld.com/t/importing-relations-for-er-diagrammer/5768/1 "2007-09-17T07:44:35Z")

</div>

We are using an Oracle 9 database without primary and foreign keys defined in the database. These are defined in an external tool. If I want to make an ER diagram I have to make al the relationships by myself (a lot of work with over 1000 tables)  
Is it possible to import these relationships from the external tool into TOAD for Data Analysis?  
With regards,  
W. Markus

---

<div class="post-metadata">

**Author:** ![Henrik\_Johnson](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/henrik_johnson/32/14_2.png) [@Henrik\_Johnson](https://forums.toadworld.com/u/Henrik_Johnson)\
**Post date:** [September 17, 2007, 7:50am UTC](https://forums.toadworld.com/t/importing-relations-for-er-diagrammer/5768/2 "2007-09-17T07:50:46Z")

</div>

Currently there is no such import. However, Toad will persist any relationships you define in it so you hopefully only need to do it one.