Chat now with support
Chat with Support

Toad Edge 2.2 - User Guide

SQL Recall View

SQL Recall displays the last 100 executed SQL statements. The statements are grouped by connection and can be filtered and pinned. You can view the entire statement simply by selecting in the view. Double-clicking a statement will cause it to be pasted into the currently active Worksheet.

Button Option Description
Filter Filters the statements according to the input. It is possible to use wildcards (? and *) and regular expressions as well as filter by multiple comma separated values
Expand All Expands all connections to display their statements
Collapse All Collapses all connections, hiding all statements
Copy Copies the currently selected statement to clipboard. You can copy multiple statements at once
Hide Unpinned Entries Hides statements that are not pinned
Pin Entry Pins the selected statement(s) so they can be filtered using the option above
Delete All Deletes all statements from the view
Delete Deletes the selected statement(s) from the view

Session Browser

The Session Browser displays database sessions and their state. The information is continuously updated and all changing values are highlighted. The sessions can be filtered and inactive sessions can be hidden. If the current user has sufficient privileges, it is also possible to terminate sessions.

To start monitoring sessions

  • Select a database connection from the Select Connection dropdown menu
  • The refresh period can be configured in the View Menu dropdown menu

To terminate a session

  • Select session that you want to terminate and then click the Kill Selected Session button

Toolbar button Name Description
Refresh Manual update of the status of all sessions
Select Connection Select a connection here in order to monitor its sessions
Hide Inactive Sessions Hides sessions that are currently not being active (e.g. sessions that are asleep)
Resize Columns to Data Resizes columns so they fit the values they contain
Kill Selected Session Terminates the selected session
View Menu Allows you to change the monitoring refresh period

Snapshots View

This view displays all taken Snapshots, grouped by connection and database. From here you can filter, export/import and also delete snapshots.

Button Option Description
Import Snapshot When a database is selected, you can import a snapshot from file (.json). This snapshot will be then listed under the database in the view
Export Snapshot Exports the selected snapshot as a JSON file
Compare Snapshot with Active Database Compares the selected snapshot with the database that is currently marked as Default in Object Explorer. Note that the currently selected connection in Connections View must have a default database for this option to be available
Compare with Each Other When you select two snapshots, you can compare them with each other using this option
Generate Script Generates a create script based on the selected snapshot. The script can be generated to clipboard, a worksheet or to a file
Delete Snapshot Removes the selected snapshot from the view and deletes the snapshot file

Text Search and Search View

Not to be confused with Object Search, Text Search allows you to find specific strings in database scripts of certain object types such as (platform dependent):

  • Aggregates
  • Procedures
  • Functions
  • Events
  • Packages
  • Triggers
  • User types
  • Views and materialized views

To search for specific text in object scripts

  1. Select Database Menu | Text Search or by pressing CTRL + H
  2. Enter the text you want to look for into the Containing text field
  3. The other field, Object name patterns, allows you to search only in objects that match the given pattern
    • For example, "*energy*" will cause the application to only search for text in objects whose names contain "energy"
  4. Select the Databases that you want to search in as well as the Object types
  5. Once finished, click Search. The results will be shown in Text Search

NOTE: You can use standard wildcard characters in both fields mentioned above. Use question mark (?) to match one character, asterisk (*) to match multiple characters and back slash (/) to escape literal characters.

You can also use multiple search patterns in the Object name patterns field as long as you separate them with commas.

Text Search

The results of Text Search are displayed in this window. By double-clicking any match, you can open the respective object in Object Detail and highlight the match.

Button Option Description
Show Next Match Jumps to the next match, automatically displaying it in Object Detail
Show Previous Match Jumps to the previous match, automatically displaying it in Object Detail
Remove Selected Matches Removes the selected matches from the view
Remove All Matches Removes all matches from the view
Expand All Expands all objects and their matches
Collapse All Collapses all matches to their respective objects
Refresh the Current Search Again Performs the current search again
Cancel Current Search Cancels the currently undergoing search
Show Previous Searches Contains a history of past searches that you can perform again
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating