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:
- Procedures
- Functions
- Events
- Triggers
- Views
To search for specific text in object scripts
- Select Database Menu | Text Search or by pressing CTRL + H
- Enter the text you want to look for into the Containing text field
- 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"
- Select the Databases that you want to search in as well as the Object types
- 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
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 |