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
Windows/Linux/Java OSX
Application
Menu
File
New Document Ctrl-N Cmd-N
Open Document Ctrl-O Cmd-O
*Close Document Ctrl-Shift-F Cmd-Shift-F
-------------------
Save Ctrl-S Cmd-S
Save As Ctrl-Shift-S Cmd-Shift-S
*Save All
Save Results Ctrl-R Cmd-R
----------
*New Editor Window Ctrl-Shift-N Cmd-Shift-N
-----------
Print Ctrl-P Cmd-P
--------------------
Mount [none] [none]
Unmount [none] [none]
----------------
Options Ctrl-Comma Cmd-Comma
-----------------
Quit Alt-F4 Cmd-Q
Edit
Cut Ctrl-X Cmd-X
Copy Ctrl-C Cmd-C
Paste Ctrl-V Cmd-V
*Paste ... Ctrl-Shift-V Cmd-Shift-V
-------------------
Undo Ctrl-Z Cmd-Z
Redo Ctrl-Shift-Z Cmd-Shift-Z
-------------------
Select All Ctrl-A Cmd-A
-------------------
Find Ctrl-F Cmd-F
*Find Next F3 Cmd-G
*Find Previous Shift-F3 Cmd-Shift-G
Replace Ctrl-H Cmd-Shift-H
-------------------
To Lower Case Ctrl-L Cmd-L
To Upper Case Ctrl-U Cmd-U
Server
New Server Group [none] [none]
Delete Server Group [none] [none]
-----------------
Register Server Clone [none] [Popup:Shift-Insert] [none]
-----------------
Register Server [none] [none]
Unregister Server [none] [none]
Server Properties [none] [none]
-----------------
Connect [none] [Popup:Ctrl-Insert] [none]
Disconnect [none] [Popup:Ctrl-Delete] [none]
-----------------
Query Analyzer Ctrl-Q Ctrl-Q
Query Analyzer Clone Ctrl-Shift-Q Ctrl-Shift-C
Query Analyzer Window Ctrl-Shift-W Ctrl-Shift-W
Query Builder Ctrl-Alt-Q Ctrl-Alt-Q
-----------------
Refresh F5 F5
Query
Parse Ctrl-Alt-A Cmd-Alt-A
Execute Ctrl-E Cmd-E
Execute Current Ctrl-Enter Cmd-Enter
Execute Edit Ctrl-Alt-Enter Cmd-Alt-Enter
Execute Explain Ctrl-Shift-Enter Cmd-Shift-Enter
Stop Ctrl-Alt-Backspace Cmd-Alt-Backspace
-----------------
Describe Ctrl-D Cmd-D
-----------------
Auto Commit Ctrl-Shift-A Cmd-Shift-A
Commit Ctrl-Shift-C Cmd-Shift-C
Rollback Ctrl-Shift-R Cmd-Shift-R
-----------------
Reconnect Ctrl-Shift-Insert [none]
-----------------
Auto Complete Ctrl-Shift-U Cmd-Shift-U
Auto On All Schemas Ctrl-Shift-O Cmd-Shift-O
Refresh Auto Schemas Ctrl-Shift-E Cmd-Shift-E
-----------------
SQL History Ctrl-Alt-H Cmd-Alt-H
-----------------
Show Text Alt-F7 Cmd-F7
Show Text History Alt-F8 Cmd-F8
Show DBMS_OUTPUT Alt-F9 Cmd-F9
Show Grid Alt-F10 Cmd-F10
Show Explain Plan Alt-F11 Cmd-F11
Show Client Statistics Alt-F12 Cmd-F12
Show Script Details [none] [none]
Automate
Introduce INSERT Statement Ctrl-Alt-I Cmd-Alt-I
Introduce UPDATE Statement Ctrl-Alt-U Cmd-Alt-U
Introduce DELETE Statement Ctrl-Alt-D Cmd-Alt-E
Introduce SELECT Statement Ctrl-Alt-S Cmd-Alt-S
-----------------
Introduce Columns Ctrl-Alt-C Cmd-Alt-C
Introduce Qualified Columns Ctrl-Alt-X Cmd-Alt-X
Introduce Value Stubs Ctrl-Alt-V Cmd-Alt-V
-----------------
Comment Statement Ctrl-Alt-Slash Cmd-Alt-Slash
Comment Line Ctrl-Slash Cmd-Slash
UnComment Comment Ctrl-Back Slash Cmd-Back Slash
-----------------
Morph To Upper Ctrl-Alt-P Cmd-Alt-P
Morph To Lower Ctrl-Alt-L Cmd-Alt-L
-----------------
Format Current Statement Ctrl-B Cmd-B
Format Script Ctrl-Shift-B Cmd-Shift-B
Tools
Import Tool [none] [none]
Export Tool [none] [none]
-----------------
Script Generator [none] [none]
ER Diagram Generator [none] [none]
Difference Tools [none] [none]
-----------------
Explain Whiteboard [none] [none]
Execution Monitor [none] [none]
DBA Tools
Oracle [none] [none]
SQL Server [none] [none]
Sybase [none] [none]
Window
MultiTab/SplitPane Results Ctrl-Alt-F7 Ctrl-Alt-F7
Show/Hide Application Toolbar Ctrl-Alt-F8 Ctrl-Alt-F8
-----------------
Show/Hide Query Toolbar Ctrl-Alt-F10 Ctrl-Alt-F10
Show/Hide Query Results Ctrl-Alt-F11 Ctrl-Alt-F12
-----------------
Show/Hide Server Browser Ctrl-Alt-F12 Ctrl-Alt-F12
-----------------
*Next Tab Alt-Right_Arrow Ctrl-Right_Arrow
*Previous Tab Alt-Left_Arrow Ctrl-Left_Arrow
*Next Inner Tab Ctrl-1 Ctrl-1
-----------------
*Rename Current Tab Ctrl-Alt-T Cmd-Alt-T
-----------------
*Close Current Tab Ctrl-F4 Cmd-W
*Close All But Current Tab [none] [none]
*Close All Tabs Ctrl-Alt-F4 Ctrl-Alt-W
-----------------
*Tab Focus Top/Bottom Ctrl-2 Ctrl-2
*Focus Tree/Document Ctrl-3 Ctrl-3
Help
*Online Documentation Shift-F1 Cmd-?
*Mailing List [none] [none]
License [none] [none]
About Aqua Data Studio [none] [none]
Query Builder
Menu
File
New Ctrl-N Cmd-N
Open Ctrl-O Cmd-O
Save Ctrl-S Cmd-S
Save As Ctrl-Shift-S Cmd-Shift-S
Save SQL As Ctrl-Alt-S Cmd-Alt-S
Save Results Ctrl-R Cmd-R
-----------------
Close Alt-F4 Cmd-Shift-W
Edit
Copy SQL Ctrl-C Cmd-C
Query
Execute Ctrl-E Cmd-E
Execute Edit Ctrl-Alt-Enter Cmd-Alt-Enter
Cancel Ctrl-Alt-Backspace Cmd-Alt-Backspace
-----------------
Group By Ctrl-G Cmd-G
Add Table Insert Insert
Window
Diagram Pane Ctrl-Alt-F9 Cmd-Alt-F9
Columns Pane Ctrl-Alt-F10 Cmd-Alt-F10
SQL Pane Ctrl-Alt-F11 Cmd-Alt-F11
Results Pane Ctrl-Alt-F12 Cmd-Alt-F12
-----------------
Next Pane Alt-Right_Arrow Ctrl-Right_Arrow
Previous Pane Alt-Left_Arrow Ctrl-Left_Arrow
Next Index Alt-PageUp Ctrl-PageUp
Previous Pane Alt-PageDown Ctrl-PageDown
-----------------
Show Datatype [none] [none]
Show Index [none] [none]
Show Table Shortcut Toolbar [none] [none]
-----------------
Clear Column Criteria Ctrl-Alt-K Cmd-Alt-K
-----------------
Quick Criteria Mode [none] [none]
Limit Add Table to User Schema [none] [none]
SQL History
Toolbar
General
Select Ctrl-R Cmd-R
Select & Close Ctrl-Shift-R Cmd-Shift-R
-----------------
Clear Selected Ctrl-D Cmd-D
Clear All Ctrl-Shift-D Cmd-Shift-D
-----------------
Find Ctrl-F Cmd-F
*Find Next F3 Cmd-G
*Find Previous Shift-F3 Cmd-Shift-G
-----------------
Save Script Ctrl-S Cmd-S
Toggle Preview Ctrl-Alt-F12 Ctrl-Alt-F12
Copy Diff Ctrl-Shift-D Cmd-Shift-D
-----------------
Close Alt-F4 Cmd-Shift-W
Explain Diagram
Menu
File
Save Image As ... Ctrl-S Cmd-S
Print Ctrl-P Cmd-P
-----------------
*Close Alt-F4 Cmd-Shift-W
View
Zoom In Ctrl-I Cmd-I
Zoom Out Ctrl-O Cmd-O
-----------------
Color Critical Path Ctrl-Alt-F6 Cmd-Alt-F6
Color Critical Node Ctrl-Alt-F7 Cmd-Alt-F7
Color Critical Operation Ctrl-Alt-F8 Cmd-Alt-F8
Table Data Editor
Menu
File
Refresh Ctrl-R Cmd-R
-----------------
Save & Refresh Ctrl-S Cmd-S
Save Changes Ctrl-T Cmd-T
Save Script Ctrl-Shift-S Cmd-Shift-S
-----------------
Close Alt-F4 Cmd-Shift-W
Edit
Insert Row Insert Insert
Delete Selected Rows Ctrl-Delete Ctrl-Delete
*Clone Selected Rows Ctrl-Shift-V Cmd-Shift-V
*Highlight Current Column Ctrl-Shift-K Cmd-Shift-K
*Highlight Current Row Ctrl-Shift-R Cmd-Shift-R
*AutoFit Column Width Ctrl-Alt-A Cmd-Alt-A
-----------------
*Find Ctrl-F Cmd-F
*Find Next F3 Cmd-G
*Find Previous Shift-F3 Cmd-Shift-G
*Replace Ctrl-H Cmd-Shift-G
-----------------
*Fill Down Ctrl-Alt-D Cmd-Alt-D
*Fill Right Ctrl-Alt-R Cmd-Alt-R
*Fill Up [none] [none]
*Fill Left [none] [none]
-----------------
Clear Changes Ctrl-Alt-Z Cmd-Alt-Z
Clear Delete Row Ctrl-Alt-E Cmd-Alt-E
Clear Cell Changes Ctrl-Alt-Y Cmd-Alt-Y
-----------------
Set Cell to NULL Delete Delete
Insert Current Date/Time Ctrl-Alt-T Cmd-Alt-T
*Insert Current Date/Only Ctrl-Shift-T Cmd-Shift-T
Edit in Window Ctrl-Alt-W Cmd-Alt-W
Window
*Next Tab Alt-Right Ctrl-Right
*Previous Tab Alt-Left Ctrl-Left
-----------------
*Focus Max Results Ctrl-Alt-M Cmd-Alt-M
-----------------
*Show/Hide Preview Pane Ctrl-Alt-F12 Cmd-Alt-F12
Editor
Keymappings
Editing
Cut Ctrl-X Cmd-X
Copy Ctrl-C Cmd-C
Paste Ctrl-V Cmd-V
-----------------
Undo Ctrl-Z Cmd-Z
Redo Ctrl-Shift-Z Cmd-Shift-Z
-----------------
Select All Ctrl-A Cmd-A
-----------------
Delete Forward Word Ctrl-Delete Cmd-Delete
Delete Backward Word Ctrl-Backspace Cmd-Backspace
Searching
Find Ctrl-F Cmd-F
Find Next F3 Cmd-G
Find Previous Shift-F3 Cmd-Shift-G
Replace Ctrl-H Cmd-Shift-H
Navigation
Start of Document Ctrl-Home Cmd-Up_Arrow
End of Document Ctrl-End Cmd-Down_Arrow
Start of Line Home Cmd-Left-Arrow
End of Line End Cmd-Right_Arrow
Next Word Ctrl-Right_Arrow Alt-Right_Arrow
Previous Word Ctrl-Left_Arrow Alt-Left_Arrow
SQL
Auto-completion Ctrl-Space Ctrl-Space
Home • Screenshots • Downloads • Documentation • Support • Licensing • Contact Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved