Versions Compared

Old Version 1

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version 2

changes.mady.by.user Wara Hermosa

Saved on

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 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 AddedNAEnables 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 AddedNADisconnects the current connection for this Query Analyzer.
Image AddedNAOpens 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 AddedNAEnables or disables the parameterized scripts.
Image AddedNASets a limit on the number of rows that Aqua Data Studio can retrieve after querying a table.
Image AddedNASelects 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.