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.
