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