Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The toolbar options provide quick access to create, modify, and save scripts in the Query Analyzer. 
Query Analyzer and Environment.pngImage RemovedImage Added
The following table describes the Toolbar options, along with the keyboard shortcut keys.

Toolbar OptionsKeyboard ShortcutDescription
Image Removed

Image Added

CTRL + N (Windows & Linux)
Command + N (Mac)

Creates a new script file. 
Image Removed

Image Added

CTRL + O (Windows & Linux)
Command + O (Mac)

Opens an existing script file.
Image Removed

Image Added

CTRL + S (Windows & Linux)
Command + S (Mac)

Saves changes to an existing file. 
Image Removed

Image Added

CTRL + SHIFT + S (Windows & Linux)
Command + Shift + S (Mac)

Saves the script as a new file.
Image Removed

Image 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 Removed

Image Added

CTRL + P (Windows & Linux)
Command + P (Mac)

Opens the print dialog.
Image Removed

Image Added

NAEnables or disables the Block Selection mode in the editor.
Image Removed

Image Added

CTRL + X (Windows & Linux)
Command + X (Mac)

Removes the selected script.
Image Removed

Image Added

CTRL + C (Windows & Linux)
Command + C (Mac)

Copies the selected script. 
Image Removed

Image Added

CTRL + V (Windows & Linux)
Command + V (Mac)

Pastes the script on a script file.
Image Removed

Image Added

CTRL + Z (Windows & Linux)
Command + Z (Mac)

Undo the last action.
Image Removed

Image Added

CTRL + SHIFT + Z (Windows & Linux)
Command + Shift + Z (Mac)

Redo the last action.
Image Removed

Image Added

CTRL + F (Windows & Linux)
Command + F (Mac)

Finds text within the opened file.
Image Removed

Image Added

CTRL + H (Windows & Linux)
Command + Shift + H (Mac)

Finds and replaces text within the opened file.
Image Removed

Image Added

CTRL + L (Windows & Linux)
Command + L (Mac)

Changes the current word or selected text to lower case.
Image Removed

Image Added

CTRL + U (Windows & Linux)
Command + U (Mac)

Changes the current word or selected text to upper case
Image Removed

Image 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 Removed

Image Added

CTRL + E (Windows & Linux)
Command + E (Mac)

Executes the script in the query window.
Image Removed

Image Added

CTRL + ENTER (Windows & Linux)
Command + Enter (Mac)

Executes the current statement, defined by the cursor position.
Image Removed

Image Added

CTRL + ALT + ENTER (Windows & Linux)
Command + Option + Enter (Mac)

Executes the SELECT statement and opens the result in an editable window.
Image Removed

Image Added

CTRL + SHIFT + ENTER (Windows & Linux)
Command + Shift + Enter (Mac)

Displays Visual Explain Plan for the current statement.
Image Removed

Image Added

CTRL + ALT + BACKSPACE (Windows & Linux)
Command + Option + Delete (Mac)

Cancels the currently executing statement or script.
Image Removed

Image Added

CTRL + SHIFT + A (Windows & Linux)
Command + Shift + A (Mac)

Determines whether commit is performed automatically after each statement is executed.
Image Removed

Image Added

CTRL + SHIFT + C (Windows & Linux)
Command + Shift + C (Mac)

Commits any active transactions.
Image Removed

Image Added

CTRL + SHIFT + R (Windows & Linux)
Command + Shift + R (Mac)

Rollbacks any active transactions.
Image Removed

Image Added

CTRL + SHIFT + INSERT (Windows & Linux)
CTRL + Option + Caps Lock + SHIFT (Mac)

Reconnects the current connection.
Image Removed

Image Added

NADisconnects the current connection for this Query Analyzer.
Image Removed

Image Added

NAOpens a new Query Analyzer with the selected server connection.
Image Removed

Image Added

CTRL + SHIFT + U (Windows & Linux)
Command + Shift + U (Mac)

Enables or disables auto-completion.
Image Removed

Image Added

CTRL + SHIFT + O (Windows & Linux)
Command + Shift + O (Mac)

Displays tables/views for all schema objects, other than just the current schema.
Image Removed

Image Added

CTRL + SHIFT + E (Windows & Linux)
Command + Shift + E (Mac)

Clears the current autocompletion cache.
Image Removed

Image Added

NAEnables or disables the parameterized scripts.
Image Removed

Image Added

NASets a limit on the number of rows that Aqua Data Studio can retrieve after querying a table.
Image Removed

Image Added

NASelects the Database (and Schema) to be used. Displays User, Connection ID, AUDSID, and other details specific to the RDBMS vendor.

...