The toolbar options provide quick access to create, modify, and save scripts in the Query Analyzer.
Image RemovedImage Added
The following table describes the Toolbar options, along with the keyboard shortcut keys.
Toolbar Options | Keyboard Shortcut | Description |
Image RemovedImage Added | CTRL + N (Windows & Linux) Command + N (Mac) | Creates a new script file. |
Image RemovedImage Added | CTRL + O (Windows & Linux) Command + O (Mac) | Opens an existing script file. |
Image RemovedImage Added | CTRL + S (Windows & Linux) Command + S (Mac) | Saves changes to an existing file. |
Image RemovedImage Added | CTRL + SHIFT + S (Windows & Linux) Command + Shift + S (Mac) | Saves the script as a new file. |
Image RemovedImage Added | CTRL + R (Windows & Linux) Command + R (Mac) | Saves the query result to a file or sends the result to the clipboard in the specified data format. |
Image RemovedImage Added | CTRL + P (Windows & Linux) Command + P (Mac) | Opens the print dialog. |
Image RemovedImage Added | NA | Enables or disables the Block Selection mode in the editor. |
Image RemovedImage Added | CTRL + X (Windows & Linux) Command + X (Mac) | Removes the selected script. |
Image RemovedImage Added | CTRL + C (Windows & Linux) Command + C (Mac) | Copies the selected script. |
Image RemovedImage Added | CTRL + V (Windows & Linux) Command + V (Mac) | Pastes the script on a script file. |
Image RemovedImage Added | CTRL + Z (Windows & Linux) Command + Z (Mac) | Undo the last action. |
Image RemovedImage Added | CTRL + SHIFT + Z (Windows & Linux) Command + Shift + Z (Mac) | Redo the last action. |
Image RemovedImage Added | CTRL + F (Windows & Linux) Command + F (Mac) | Finds text within the opened file. |
Image RemovedImage Added | CTRL + H (Windows & Linux) Command + Shift + H (Mac) | Finds and replaces text within the opened file. |
Image RemovedImage Added | CTRL + L (Windows & Linux) Command + L (Mac) | Changes the current word or selected text to lower case. |
Image RemovedImage Added | CTRL + U (Windows & Linux) Command + U (Mac) | Changes the current word or selected text to upper case |
Image RemovedImage Added | CTRL + ALT + A (Windows & Linux) Command + Option + A (Mac) | Parses the script and displays a list of the commands to be executed on the server. |
Image RemovedImage Added | CTRL + E (Windows & Linux) Command + E (Mac) | Executes the script in the query window. |
Image RemovedImage Added | CTRL + ENTER (Windows & Linux) Command + Enter (Mac) | Executes the current statement, defined by the cursor position. |
Image RemovedImage Added | CTRL + ALT + ENTER (Windows & Linux) Command + Option + Enter (Mac) | Executes the SELECT statement and opens the result in an editable window. |
Image RemovedImage Added | CTRL + SHIFT + ENTER (Windows & Linux) Command + Shift + Enter (Mac) | Displays Visual Explain Plan for the current statement. |
Image RemovedImage Added | CTRL + ALT + BACKSPACE (Windows & Linux) Command + Option + Delete (Mac) | Cancels the currently executing statement or script. |
Image RemovedImage Added | CTRL + SHIFT + A (Windows & Linux) Command + Shift + A (Mac) | Determines whether commit is performed automatically after each statement is executed. |
Image RemovedImage Added | CTRL + SHIFT + C (Windows & Linux) Command + Shift + C (Mac) | Commits any active transactions. |
Image RemovedImage Added | CTRL + SHIFT + R (Windows & Linux) Command + Shift + R (Mac) | Rollbacks any active transactions. |
Image RemovedImage Added | CTRL + SHIFT + INSERT (Windows & Linux) CTRL + Option + Caps Lock + SHIFT (Mac) | Reconnects the current connection. |
Image RemovedImage Added | NA | Disconnects the current connection for this Query Analyzer. |
Image RemovedImage Added | NA | Opens a new Query Analyzer with the selected server connection. |
Image RemovedImage Added | CTRL + SHIFT + U (Windows & Linux) Command + Shift + U (Mac) | Enables or disables auto-completion. |
Image RemovedImage Added | CTRL + SHIFT + O (Windows & Linux) Command + Shift + O (Mac) | Displays tables/views for all schema objects, other than just the current schema. |
Image RemovedImage Added | CTRL + SHIFT + E (Windows & Linux) Command + Shift + E (Mac) | Clears the current autocompletion cache. |
Image RemovedImage Added | NA | Enables or disables the parameterized scripts. |
Image RemovedImage Added | NA | Sets a limit on the number of rows that Aqua Data Studio can retrieve after querying a table. |
Image RemovedImage Added | NA | Selects the Database (and Schema) to be used. Displays User, Connection ID, AUDSID, and other details specific to the RDBMS vendor. |
See Also, Menus and Toolbars.