Chat now with support
Chat with Support

Toad Edge 1.1 - User Guide

Snapshots View

User Interface > 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

User Interface > 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:

  • Procedures
  • Functions
  • Events
  • Triggers
  • 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 Search View

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.

Search View

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

Worksheet and Result Set

Worksheet

User Interface > Worksheet and Result Set > Worksheet

Worksheet is one of the most basic tools in Toad Edge. It is used to interact with a database using SQL scripts and queries. Coupled with additional features such as Content Assist and Outline View, you can create and modify queries in a fast and efficient manner.

NOTE: If you do not specify a database, the scripts and queries will be executed on the Default database

To open a Worksheet

  • Click the Worksheet button on main toolbar to open a blank Worksheet
Worksheet toolbar
Button Option Description
Execute All Statements Executes all statements in the query
Execute From Current Position Executes all statements from the current cursor position in the query
Execute to Current Position Executes all statements up to the current cursor position in the query
Execute SQL Statement Executes the statement where the cursor is currently placed. Can be used to execute multiple selected statements at once
Cancel Query Stops the query that is currently being executed
Commit Transaction Commits the changes included in the current transaction. See AutoCommitfor more information
Rollback Transaction Cancels the changes included in the current transaction. See AutoCommitfor more information
Select Connection Allows you to select a connection using which the query should be executed
Show Result Set Displays Result Set either in Vertical Layout or Horizontal Layout
Worksheet context menu options
Option Description
Revert Restores the last saved state of the Worksheet
Open Opens the selected object in Object Detail. Note that this option only works when you place the cursor in or select a highlighted object name, i.e. an object that already exists in the database
Make Code Statement Generates Java code which recreates the selected query as a StringBuilder object. The code is copied to clipboard
Strip Code Statement When selecting Java code which contains a SQL query, this option will strip away the Java code and keep the SQL code. The code is copied to clipboard
Formatting Provides options to switch the selected text to uppercase/lowercase or to enclose it in text/object quotes
Quick Outline Displays the basic structure of a Worksheet if it contains multiple queries
Toggle Comment Comments out the selected lines
Hint Window

When you hover over a database object name, Hint Window is displayed to provide you with quick information about the object. Hover over the bottom bar of the window to see additional options.

Button Option Description
Open Declaration Opens the object in Object Detail
Show Script Displays the object SQL code in a new Worksheet
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating