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!
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:
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.
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.
If you need any help, please write me back. Thanks.
Vladka Message was edited by: vladka