Chat now with support
Chat with Support

Toad for Oracle 13.1.1 - Getting Started Guide

Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Copy Objects to Another Schema

Work with Database Objects > Copy Objects to Another Schema

You can copy objects to another schema.

To copy objects to another schema

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Right-click the object you want to copy in the left-hand side and select Create in another schema.
  3. Select export settings and click OK. See Export DDL in the online help for more information.
  4. Enter the destination connection and destination schemas.
  5. To review the script to create the objects, click the Script tab.
  6. Click Execute.

 

Create or Alter Objects

Work with Database Objects > Create or Alter Objects

Toad lets you select Oracle object parameters and generate a DDL statement to create or alter objects. It is generally a good idea to review the DDL statement before executing it. When you execute the statement, Toad passes it to the database, and the object is created or altered.

The options to create or alter an object in Toad follow the parameters defined by Oracle. If you need clarification on what an option means or how it should be used, see Oracle's documentation for more information. Oracle provides detailed documentation about objects, including their purpose, properties, and restrictions.

Notes:

To create an object

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Select Database | Create | <Object type>.

  3. Complete the fields as necessary.

  4. To add the object to the Project Manager, select Add to Project Manager.
  5. To view the CREATE statement, click Show SQL or select the SQL tab.
  6. Click OK or Execute to create the object immediately. You can also schedule the script to run later.

To alter an object

To alter or edit an object, double-click on it in the Schema Browser. To rename an object (if permitted) press F2.

Note: You cannot make any changes on the Alter Index | Column tab because Oracle does not permit an index to be altered that way. To alter an index, send the script to the editor (with a DROP command), edit the script, and then run it. As an alternative, you can right-click the index then choose Create Like. Enter a name for the new index, make the changes, and then drop the original index.

 

Use Existing Object as Template for New Objects

Work with Database Objects > Use Existing Object as Template for New Objects

You can use an existing object as a template for creating a new object. Toad loads the original object's properties in the Create window for you to edit as necessary and execute.

Note: This feature is not available for all object types.

To create an object based on an existing one

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Right-click the object you want to use as a template in the left-hand side and select Create Like.
  3. Complete the fields as necessary.
  4. To view the CREATE statement, click Show SQL or select the SQL tab.
  5. Click OK or Execute to create the object immediately. You can also schedule the script to run later.

 

Drop (Delete) Objects

Option Description

Cascade Constraints

Deletes all foreign keys that reference the table.

Purge

Bypasses the recycle bin and completely drops the table. Purged tables cannot be recovered.
Related Documents