Chat now with support
Chat with Support

Toad for Oracle 2025 R3 - 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

Work with Database Objects

Toad enables you to view, add, modify, and get information about database objects. You can work with these objects quickly and without having to use SQL commands.

 

Describe Objects

You can use the Describe Objects feature anywhere in Toad to find objects and display their information in the Describe Objects window. The Describe Objects window displays the same information you would see in the right-hand side of the Schema Browser.

Note: You can describe many objects types through database links. However, the following object types are not supported: policy, policy group, java, refresh group, resource groups/plans, sys privs, and transformations.

To immediately describe the object

  1. Select the object and press F4.

    Tip: You can also right-click the object and select Describe.

  2. If multiple objects have the same name, select the appropriate object from the Multiple Object Found window. (This only applies to the object types in DBA_OBJECTS.)

To specify the object schema and name before describing the object

  1. Press CTRL+D to open the Quick Describe window.
  2. Enter the object name in the Object Name field. You can complete the rest of the fields to refine your search. These fields are helpful when multiple schemas may contain objects with the same name, or when different object types have the same name (for example, a SYSTEM user and table).
  3. Click Describe and Close to open the object in the Describe Objects window and close the Quick Describe window. If you click Describe instead, the Quick Describe window remains open.

 

Find in Objects

  • From the Toad toolbar, click .
  • From the Search menu, select Object Search.
  • On the DB Misc tab of the Automation Designer, double-click (Object Search) to add the action to your app, then double-click the action to open the Properties dialog.

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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating