Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Wednesday, 17 October 2012

Create Script and Generate ER Diagram Using Toad:

        On the Schema browser select the table
        Right click on the table and select “create script
        Set the object and output path for script.
Then Select the script option as per the requirement and press ok

Generate ER Diagram
        On the Schema browser select the table
        Right click on the table and select “ER Diagram”
Now you can Copy and paste this diagram to anywhere else.

Create an Object based on Existing object using Toad
On the Schema Browser select and right click on the object and select “Create Like”.
Complete the field (Schema name, Object Name) as necessary.
You can view the Create statement by clicking on Show SQL.
Do not forget to change the name of constraint (if exist any)
Click OK or Execute. You can also schedule the script to run the later.

0 comments:

Post a Comment