Object Explorer
Object Explorer allows you to comfortably navigate your databases and view their objects. The contents of the explorer change depending on the currently selected connection in Connections View. There are various options available in the context menu depending on the type of object you select.
|
|
Note: To quickly find a specific object in any database of a connection, use the Object Search function (CTRL (⌘) + SHIFT + D) |
Default database
You can set any of your databases as default. This means that scripts in Worksheet will be executed on the selected database by default if you do not specify another database.
To set a default database
- In Object Explorer, right-click any database and select Set Database as Default
Object Explorer toolbar
| Button | Option | Description |
|---|---|---|
 |
Link with Editor | If enabled, bringing a window (Worksheet, Object Detail and Describe Object...) into focus will highlight the window in Connections View and selecting the window in Connections view will bring it into focus |
 |
Define Visible Categories | Opens a dialog where you can set which categories / object types should be shown or hidden |
 |
Open Objects in Common Detail Window | If enabled, allows you to use the Describe Object window. See Object Detail and Describe Object for more information |
 |
Refresh | Refreshes the status of the selected object / object type / database |
 |
Rename Selected Object | Opens a dialog where you can change the name of the selected object |
 |
Drop Selected Objects | Deletes the selected object(s) from the database |
 |
New *object* | Creates a new specific object depending on the object type you are currently viewing |
 |
Filter | Filters the objects in Object Explorer according to the input. It is possible to use wildcards (? and *) and regular expressions as well as filter by multiple comma separated values |
Object Search
This tool allows you to search for any database object of the currently selected connection in Connections View.
To search for object(s)
- Open Object Search window by clicking the Object Search button in the application toolbar or by pressing CTRL (⌘) + SHIFT + D
- From the Databases section, select databases that should be searched
- In the Object types section, check the object types that should be included in the search
- Start writing the object name. The search results will be displayed as you write
You can use any of the following in your search query:
- Simple text - Toad Edge will look for the literal text string, the search is case insensitive
- For example, "air" will match "airport_frequencies", but not "test_airport"
- Wildcard characters - where a question mark (?) represents any one character and an asterisk (*) any number of any characters
- For example, "?cc*s" will match "ACCESS_TIME" as well as "accounts", but not "accident_data"
- Multiple values - use multiple search patterns, separated by commas (,)
- For example, "test, customer" will match both "test_function" and "customer_id"
- Regular expressions - enclosed in square brackets ([regex])
- For example, "[^[cd]u+]" will match "DURATION" or "customer_id", but not "concurrent_connections"
Outline View
The contents of the View change depending on what are you doing in Toad Edge. Its functionality can be divided into several modes:
|
|
TIP: In all modes except for Schema Compare, you can click on any item in the Outline to navigate to the object quickly in the other UI element. For example, clicking on a specific constraint in database object outline mode switches Object Detail/Describe Object to Constraints tab and highlights the selected constraint. |
Code outline
When editing procedures, functions, etc., Outline displays the code structure, including variables.
Database object outline
In this mode, Outline displays important details of database objects displayed in Object Detail and Describe Object.
JSON outline
This mode is triggered by opening a JSON column value in JSON support and JSON Editor. In this case, the complete structure of the current JSON value, including nested values, is shown.
Schema Compare settings
When in Schema Compare, Outline displays comparison settings which determine what is considered a difference and what should be ignored.
Difference Fragmentation slider further determines the precision of difference finding. The further it goes left, the smaller and more precise the differences are, such as specific values or words. The further it goes right, the looser and more flexible the differences are, such as entire statements or blocks of code.
| Slider position | Difference precision |
|---|---|
 |
 |
 |
 |
Quick Doc View
Quick Doc displays brief, relevant information about the currently selected objects.
Quick Doc has two modes:
- Object Explorer mode
- Comparison mode
Object Explorer mode
This mode is used most of the time. As you select various objects in Object Explorer, Quick Doc displays basic information about them.
Comparison mode
This mode is triggered when you work with Overview Grid as part of About Schema Compare or Repository. It displays specific differences between two objects in a row that is currently selected in the grid. The view becomes very useful in cases where there are many differences.
Quick Doc view toolbar
| Button | Option | Description |
|---|---|---|
| |
Link with Selection | If enabled, Quick Doc automatically displays information every time you select an object in Object Explorer or a record in the Overview Grid |
 |
Open Declaration | (Object Explorer mode only) Opens the currently described object in Object Detail and Describe Object |