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. 
Image Added
The following table describes the Toolbar options, along with the keyboard shortcut keys.

Toolbar OptionsKeyboard ShortcutDescription

Image Added

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

Creates a new script file. 

Image Added

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

Opens an existing script file.

Image Added

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

Saves changes to an existing file. 

Image Added

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

Saves the script as a new file.

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 Added

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

Opens the print dialog.

Image Added

NAEnables or disables the Block Selection mode in the editor.

Image Added

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

Removes the selected script.

Image Added

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

Copies the selected script. 

Image Added

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

Pastes the script on a script file.

Image Added

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

Undo the last action.

Image Added

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

Redo the last action.

Image Added

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

Finds text within the opened file.

Image Added

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

Finds and replaces text within the opened file.

Image Added

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

Changes the current word or selected text to lower case.

Image Added

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

Changes the current word or selected text to upper case

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 Added

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

Executes the script in the query window.

Image Added

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

Executes the current statement, defined by the cursor position.

Image Added

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

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

Image Added

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

Displays Visual Explain Plan for the current statement.

Image Added

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

Cancels the currently executing statement or script.

Image Added

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

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

Image Added

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

Commits any active transactions.

Image Added

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

Rollbacks any active transactions.

Image Added

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

Reconnects the current connection.

Image Added

NADisconnects the current connection for this Query Analyzer.

Image Added

NAOpens a new Query Analyzer with the selected server connection.

Image Added

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

Enables or disables auto-completion.

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 Added

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

Clears the current autocompletion cache.

Image Added

NAEnables or disables the parameterized scripts.

Image Added

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

Image Added

NASelects 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