Home Home Screenshots Download Documentation Contact Licensing Licensing

Documentation: Aqua Data Studio 6.0 - New Features     HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)
  Getting Started
  Installation
  JDBC Drivers
  I. Oracle
  II. DB2 UDB
  III. SQL Server
  IV. Sybase ASE
  V. Sybase Anywhere
  VI. Sybase IQ
  VII. Informix
  VIII. PostgreSQL
  IX. MySQL
  Memory Configuration
  Character sets
  Registering Servers
  I. MSDE 2000
  II. SQL Express 2005
  III. PostgreSQL SSL
  Application
  I. Browser and Scripting
  II. Visual Editing
  III. SQL History
  IV. Shortcut Toolbar
  V. Key Mappings
  VI. Custom Keymap Profiles
  VII. Options
  VIII. Settings
  Query Window
  I. Basics
  II. Toolbar
  III. Server Side Comments
  IV. SQL Automation
  V. Variable Binding
  VI. Results
  VII. Save Results
  VIII. Auto-completion
  IX. SQL Formatter
  X. Permissions
  XI. Parameterized
  Editors
  I. SQL Editor
  II. Text Editor
  III. HTML Editor
  IV. XML Editor
  V. Regular Expressions
  Image Viewer
  Visual Explain Plan
  I. Basics
  II. Explain Plan
  III. Explain Diagram
  IV. Whiteboard
  Procedure/Package Editor
  Tools
  I. Table Data Editor
  II. Script Generator
  III. ER Diagram
  IV. Query Builder
  V. Import Tool
  VI. Export Tool
  VII. Execution Monitor
  Difference Tools
  I. Schema Diff
  II. Tab Diff
  III. Directory Diff
  IV. File Diff
  V. Copy History Diff
  Oracle DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Rollback Manager
  IV. Log Manager
  V. Security Manager
  VI. Session Manager
  VII. SGA Manager
  VIII. Server Statistics
  SQL Server DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager
  V. SQL Agent Manager
  Sybase DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager


Aqua Data Studio's Query Analyzer toolbar provides quick access to the query editing and execution functions.

New Query - Create a new script file
Open Script - Open an existing script file
Save Query - Save the current Query Analyzer script to a file
Save Query As - Save the current Query Analyzer script as a new file
Save Results - Save the query results as a file or send them to the Clipboard
Print - Print a hard-copy of the selected panel
Cut - Cut selected text to the Clipboard
Copy - Copy selected text to the Clipboard
Paste - Paste text from the Clipboard to the current cursor position
Undo - Undo the last action
Find - Find text within the currently selected panel
Replace - Replace text within the currently selected panel
To Lower Case - Convert the current word or selected text to lower case
To Upper Case - Convert the current word or selected text to upper case
Parse - Parse the script and display a list of the commands as they will be execute on the server
Execute - Execute every script in the query window
Execute Current - Execute the current statement, defined by the cursor position
Execute Edit - Execute the current single-table SELECT statement and open results in an editable window
Execute Explain - Display visual explain plan for the current statement
Stop - Cancel the currently executing statement or script
Auto Commit - Determines whether commit is performed automatically after each statement execution
Commit - Commits any active transactions
Rollback - Rollback any active transactions
Reconnect - Reconnect the current connection
Auto Complete - Enable/Disable auto-completion
Auto On All Schemas - Auto-completion displays tables/views for all schema objects, other than just the current schema
Refresh Auto Schema - Clears the current auto-completion cache

Max Results - Set the max number of rows returned by a query
Database - Change the database you are analyzing
Home Screenshots Downloads Documentation Support Licensing Contact Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved