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 |
Not to be confused with Object Search, Text Search allows you to find specific strings in database scripts of certain object types:
To search for specific text in object scripts
|
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. |
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 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
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 |
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 |
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 |
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy