Toad World® Forums

creating a one-to-one relationship


#1

hi all…i’ve been using toad for 2 days and i just wonder how do i create a one-to-one relationship between tables??..it seems that everytime i relate tables the relationshp is always one-to-many…and how do i import-export databases in toad??..thanks!..need ur answers ASAP! :smiley:


#2

Hi,

how do i create a one-to-one relationship between tables?

Edit the relationship. See the Relationship Properties dialog | General tab | Cardinality area | in the Cardinality box, write 1 instead of N.

how do i import-export databases in toad?

Import: See File | Reverse Engineering.
Flash movie on RE:
http://modeling.inside.quest.com/entry.jspa?externalID=1673&categoryID=158

Export:
DDL/SQL script generation - Press F9 to open the Script Generation dialog where you can generate DDL script for the model you created in TDM.
Flash movie:
http://modeling.inside.quest.com/entry.jspa?externalID=1667&categoryID=158

Alter script generation is also supported in TDM. In current Beta version only for these databases: Oracle 9i, Oracle 10g, Oracle 11g, MS SQL Server 2005 and MS SQL Server 2008 models - To run the generated script in db, you need to use another tool, e.g. Toad for Oracle for Oracle db.


Please feel free to watch other flash movies and have a look at the Help file or Manual for other information.
http://modeling.inside.quest.com/kbcategory.jspa?categoryID=158
http://modeling.inside.quest.com/kbcategory.jspa?categoryID=116

If you need any help, please write me back. Thanks.

Regards,

Vladka Message was edited by: vladka