立即与支持人员聊天
与支持团队交流

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

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.

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

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.

 

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.

Flashback Tables (Recover Dropped Tables)

A recycle bin is available to retrieve tables and associated objects (such as indexes, constraints, and triggers) you have dropped from the database. From the Schema Browser's Recycle Bin page you can access this bin and retrieve dropped tables if necessary.

To flashback a table

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Select the Recycle Bin in the left-hand side.
  3. Select the table you want to recover from the list and click .
  4. Restore the table with the original name or a new one.

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级