In Toad you use the Schema Browser to work with database objects.
Welcome to Toad
Toad Resources
Jump search
Toad Advisor
Toad World
Toad Web-based Training
Retrieve License Keys
Create Support Bundles
Required Privileges
Create and Manage Database Connections
About Database Connections
Create or Edit a Connection
Save Connection Passwords
Import/Export Connection Settings
Automatically Connect on Startup
Use Previous Connections
Change Active Connection in Window
Test Connections
End Connections
Commit or Rollback Changes
Editor Basics
About the Editor
About the Output Window
About the Results Grids
Toggle Fullscreen Editor
Open and Save Files
Change Current Schema
Find text in the Editor
Create a Find and Replace Macro
Use Bookmarks
Find in Files
Move Between Editor Tabs
Automatically Back Up the Editor
Use an External Editor
Schema Browser Basics
About the Schema Browser
View Icon Legend
Automatically Refresh the Data Grid
Create Schema Browser Filters
Create Default Schema Browser Filters
Apply Saved Schema Browser Filters
Quick-filter the Left-hand Side
Filter Data in the Schema Browser
Clear Filters
Data Grid Basics
About Data Grids
Anchor Column in Data Grid
Hide Columns
Understand Time Values
Sort and Group Data
Find in Grid
Filter Data
Preview Selected Column
Include Row Numbers
Copy Column Names to the Clipboard
Work with Data
Understand Editable Resultsets
Copy Data to Another Schema
Compare Data
Review Differences
Compare Data Duplicates
Insert/Delete Rows
Post/Revert Edited Data
Edit Data in Popup Editor
Perform Calculations on Grid Cells
Use the Calculator
Work with Database Objects
Describe Objects
Find in Objects
Copy Objects to Another Schema
Create or Alter Objects
Use Existing Object as Template for New Objects
Drop (Delete) Objects
Flashback Tables (Recover Dropped Tables)
View Parent/Child Datasets
View/Modify Privileges
Configure Grantees
Look Up Foreign Keys
Compare Objects
Rebuild Objects
Work with Code
Write Statements and Scripts
Customize your Toad Environment
Use the Code Navigator
Use the Object Palette
Use Code Completion Templates
Create Make Code Templates
Use Code Snippets
Use a Pick List to Complete Code
Use Query Templates
Format Code
Highlight Statements
Fold Code Segments
Change Text to Upper or Lower Case
Swap with Previous Line
View File Differences
Preview Query Results
Save Query Results
Copy Statements between Toad and Development Tools
View Code Statistics
Work with the Query Builder
About the Query Builder
How to use the Model Area
Build a Query
Create a Sub-Query
Populate the Where Clause
Populate the Having Clause
Use the Generated Query
Saving Toad Query Results
Execute Statements and Scripts
About Executing Scripts
Execute Single Statements
Execute Scripts in the Editor
Execute SQL with SQL*Plus
Save Statements (SQL Recall)
Work with PL/SQL Objects
Load Database Object
Reload Object
Create New PL/SQL Object
Extract Procedures
Generate DBMS Output
Execute SQL Statements within PL/SQL
Execute PL/SQL
Debug
About Debugging
Debug PL/SQL
Analyze Code
Optimize SQL
Minimum Oracle Database Requirements
Start Debugging
Set Parameters
Set Parameters in Triggers
Handle Dependencies
Call Stack Window
Stop the Debugger
Prepare PL/SQL Code for Production
View Debug Results
Use DBMS Output
Create and Run Unit Tests
Debug Scripts
Set Breakpoints
Set Watches
Customize Connections
Customize Workspaces
Use Shortcut Keys
Customize Toolbars, Menus and Commands
Use Other Quest Software Products with Toad
Enable Self-Configuring Menus
Show/Hide Toolbars
Rename Toolbars, Menus or Commands
Create New Toolbars, Menus and Commands
Add, Reorder and Remove Commands
Show Additional Menus
Delete a Menu
Reset Default Toolbars
Lock Toolbars
Effect of Upgrades on Customizations
Customize the Editor
Customize the Schema Browser
Customize Schema Drop-Downs
Use an External Editor
Note: If you have not saved the contents of the Toad Editor to a file, Toad prompts for a filename before launching the external editor.
Schema Browser Basics
Schema Browser Basics
About the Schema Browser
The Schema Browser allows you to view, add, and modify database objects. It also displays detailed information about a selected object. For example, the detailed information for a table includes its subpartitions, columns, indexes, data, grants, and so on.
To open the Schema Browser
Click 
Notes:
- Some Schema Browser features are only available with the DB Admin Module, which is included in several Toad Editions or can be purchased separately.
- You can set the Schema Browser to open automatically when a new connection is made. Select View | Toad Options | Windows and select the Auto Open checkbox of the Schema Browser row.
Schema Browser Panes
The Schema Browser is divided into two panes to help you review objects and their details:
| Pane | Description |
|---|---|
| List of objects (left-hand side) |
The left-hand side of the Schema Browser is also known as the "LHS" (Left-Hand Side) and is referred to as such throughout the documentation. The LHS provides a list of objects that you can view. In general, you select a schema and an object type, and the list refreshes to display the relevant objects. You can filter the objects and save your filters for future use. See About Schema Browser Filters in the online help for more information. The list can display additional information about the objects, such as the tablespace and number of rows. To view additional information, right-click a column in the left-hand side and select additional columns to display. (This feature is unavailable with the tree view display.) Tip: In drop-down mode, you can hide leading characters of object names in the left-hand side. Right click a column and select Hide leading characters of name. The display resets when you change the schema or connection. |
|
Object details (right-hand side) |
The right-hand side of the Schema Browser is also known as the "RHS" (Right-Hand Side) and is referred to as such throughout the documentation. The RHS initially displays the same list of objects as the left-hand side. When you select an object on the left-hand side, Toad displays its details in the right-hand side. This format makes it easy for you to compare details between objects of the same type. From the Schema Browser you can drop most objects, enable/disable applicable objects, and disable triggers for a table or for an entire schema. You can recompile procedures, functions, packages, triggers, and views, or they can be extracted from the database and loaded into the clipboard or Editor. If Team Coding is enabled, you can view status and collection information. |
|
Tips:
| |
in the toolbar or select multiple objects on the left-hand side.
Customize the Schema Browser
You can customize how the Schema Browser displays to better suit the way you work. The most common customization is to change how object types display in the left-hand side.
Toad also provides dozens of options to further customize the display and behavior of the Schema Browser.
View Icon Legend
Many of the panes within the Schema Browser have icons to identify the objects. Toad includes an Icon Legend that you can use to easily decipher these images.
To view the icon legend
- Click
on the Schema Browser toolbar.