20.10 Key Mapping Options and Key Assist Tool (Revision #10)

Key Mapping Options

Key Mappings - The Key Mapping section allows you to configure new key mapping profiles with new key bindings. This allows you to configure any keystroke to any action.

Key Assist - The Key Mapping Assistant allows a user to quickly lookup an action and find the corresponding key binding.

In order to access key bindings the user may press Help->Key Assist from the menu or the corresponding hot key which will popup a dialog containing a list of categories, actions and corresponding key bindings. The dialog contains a quick filter allowing the user to quickly isolate the exact action he/she is looking for.

Using the button "Edit Keys" from the Key Assist dialog, you may also quickly access the configurable key bindings if you want to edit the current key binding for any action.

Application - Keymappings (default settings)

	Windows/Linux/Java	OS X note on function keys
General
File: New Document	Ctrl+N	Cmd+N
File: Open Document	Ctrl+O	Cmd+O
File: Close Document	Ctrl+F4	Cmd+W
File: Save	Ctrl+S	Cmd+S
File: Save As	Ctrl+Shift+S	Cmd+Shift+S
File: Save All
File: Save Results	Ctrl+R	Cmd+R
File: New Editor Window	Ctrl+Shift+N	Cmd+Shift+N
File: Print	Ctrl+P	Cmd+P
File: Options	Ctrl+Comma	Cmd+Comma
File: New Frame Window	Ctrl+Alt+N	Cmd+Alt+N
File: Close Window	Alt+F4	Cmd+Q
Edit: Cut	Ctrl+X	Cmd+X
Edit: Copy	Ctrl+C	Cmd+C
Edit: Paste	Ctrl+V	Cmd+V
Edit: Paste ...	Ctrl+Shift+V	Cmd+Shift+V
Edit: Undo	Ctrl+Z	Cmd+Z
Edit: Redo	Ctrl+Shift+Z	Cmd+Shift+Z
Edit: Select All	Ctrl+A	Cmd+A
Edit: Incremental Find	Ctrl+F	Cmd+F
Edit: Find	Ctrl+Alt+F	Ctrl+Alt+F
Edit: Find Next	F3	Cmd+G
Edit: Find Previous	Shift+F3	Cmd+Shift+G
Edit: Replace	Ctrl+H	Cmd+Shift+H
Edit: Goto	Ctrl+G	Cmd+G
Edit: Toggle Bookmark	Ctrl+Shift+M	Cmd+Shift+M
Edit: Previous Bookmark	Ctrl+Shift+Up	Cmd+Shift+Up
Edit: Next Bookmark	Ctrl+Shift+Down	Cmd+Shift+Down
Edit: To Lower	Ctrl+L	Cmd+L
Edit: To Upper	Ctrl+U	Cmd+U
Server: New Server Group
Server: Register Server Clone	Shift+Insert	Shift+Insert
Server: Register Server	Insert	Insert
Server: Server Properties	Ctrl+Shift+P	Cmd+Shift+P
Server: Connect	Ctrl+Insert	Ctrl+Insert
Server: Disconnect	Ctrl+Delete	Ctrl+Delete
Server: Query Analyzer	Ctrl+Q	Ctrl+Q
Server: Query Analyzer Clone	Ctrl+Shift+Q	Ctrl+Shift+C
Server: Query Analyzer Clone with Content	Ctrl+Shift+C	Ctrl+Shift+T
Server: SQL Shell
Server: Query Analyzer Window	Ctrl+Shift+W	Ctrl+Shift+W
Server: Query Builder	Ctrl+Alt+Q	Ctrl+Alt+Q
Server: Refresh	F5	F5
Server: Delete	Delete	Delete
Query: Parse	Ctrl+Alt+A	Cmd+Alt+A
Query: Execute	Ctrl+E	Cmd+E
Query: Execute Current	Ctrl+Enter	Cmd+Enter
Query: Execute Edit	Ctrl+Alt+Enter	Cmd+Alt+Enter
Query: Execute Explain	Ctrl+Shift+Enter	Cmd+Shift+Enter
Query: Stop	Ctrl+Alt+Backspace	Cmd+Alt+Backspace
Query: Describe	Ctrl+D	Cmd+D
Query: Auto Commit	Ctrl+Shift+A	Cmd+Shift+A
Query: Commit	Ctrl+Shift+C	Cmd+Shift+C
Query: Rollback	Ctrl+Shift+R	Cmd+Shift+R
Query: Reconnect	Ctrl+Shift+Insert	Ctrl+Alt+Shift+Up Arrow
Query: Auto Complete	Ctrl+Shift+U	Cmd+Shift+U
Query: Auto on All Schemas	Ctrl+Shift+O	Cmd+Shift+O
Query: Refresh Auto Schema	Ctrl+Shift+E	Cmd+Shift+E
Query: SQL History	Ctrl+Alt+H	Ctrl+Alt+H
Query: Show Text	Alt+F7	Fn+Cmd+F7
Query: Show Text History	Alt+F8	Fn+Cmd+F8
Query: Show DBMS_OUTPUT	Alt+F9	Fn+Cmd+F9
Query: Show Form
Query: Show Grid	Alt+F10	Fn+Cmd+F10
Query: Show Explain Plan	Alt+F11	Fn+Cmd+F11
Query: Show Client Stats	Alt+F12	Fn+Cmd+F12
Query: Show Pivot Table
Query: Show Script Details
Automate: Introduce INSERT Stmt	Ctrl+Alt+I	Cmd+Alt+I
Automate: Introduce UPDATE Stmt	Ctrl+Alt+U	Cmd+Alt+U
Automate: Introduce DELETE Stmt	Ctrl+Alt+D	Cmd+Alt+E
Automate: Introduce SELECT Stmt	Ctrl+Alt+S	Cmd+Alt+S
Automate: Introduce Columns	Ctrl+Alt+C	Cmd+Alt+C
Automate: Introduce Qualified Columns	Ctrl+Alt+X	Cmd+Alt+X
Automate: Introduce Value Stubs	Ctrl+Alt+V	Cmd+Alt+V
Automate: Comment Statements	Ctrl+Alt+Slash	Cmd+Alt+Slash
Automate: // Comment Line	Ctrl+Slash	Cmd+Slash
Automate: -- Comment Line	Ctrl+MINUS	Cmd+MINUS
Automate: /* Comment Block	Ctrl+Shift+Slash	Cmd+Shift+Slash
Automate: Morph to Upper Case	Ctrl+Alt+P	Cmd+Alt+P
Automate: Morph to Lower Case	Ctrl+Alt+L	Cmd+Alt+L
Automate: Morph to Delimited List	Ctrl+Alt+O	Ctrl+Alt+O
Automate: Format Current Statement	Ctrl+B	Cmd+B
Automate: Format Script	Ctrl+Shift+B	Cmd+Shift+B
Tools: Import Tool
Tools: Export Tool
Tools: Script Generator
Tools: Server Script Generator
Tools: ER Diagram Generator
Tools: Schema Compare
Tools: Tab Compare
Tools: File Compare
Tools: Dir Compare
Tools: Results Compare	Ctrl+Shift+K	Cmd+Shift+K
Tools: Copy Compare	Ctrl+Shift+D	Cmd+Shift+D
Tools: Explain Whiteboard
Tools: Execution Monitor
Window: MultiTab/SplitPane Results	Ctrl+Alt+F7	Fn+Ctrl+Alt+F7
Window: Show/Hide Application Toolbar	Ctrl+Alt+F8	Fn+Ctrl+Alt+F8
Window: Show/Hide Query Toolbar	Ctrl+Alt+F10	Fn+Ctrl+Alt+F10
Window: Show/Hide Editor Window	Ctrl+Alt+F6	Fn+Ctrl+Alt+F6
Window: Show/Hide Query Results	Ctrl+Alt+F11	Fn+Ctrl+Alt+F11
Window: Show/Hide Server Browser	Ctrl+Alt+F12	Fn+Ctrl+Alt+F12
Window: Show/Hide Panel Toolbar
Window: Next Tab	Alt+Right	Ctrl+Right
Window: Previous Tab	Alt+Left	Ctrl+Left
Window: Next Inner Tab	Ctrl+1	Ctrl+1
Window: Rename Current Tab	Ctrl+Alt+T	Ctrl+Alt+T
Window: Close Current Tab	Ctrl+F4	Cmd+W
Window: Close All But Current Tab
Window: Close All Tabs	Ctrl+Alt+F4	Cmd+Alt+W
Window: Tab Focus Top/Bottom	Ctrl+2	Ctrl+2
Window: Focus Tree/Document	Ctrl+3	Ctrl+3
Help: Key Assist	Ctrl+Shift+L	Ctrl+Shift+L
Help: Online Documentation	Shift+F1	Cmd+Shift+\
Help: Answers
Help: Community Discussions
Help: License
Help: About Aqua Data Studio
Table Data Editor
File: Refresh	Ctrl+R	Cmd+R
File: Save & Refresh	Ctrl+S	Cmd+S
File: Save Changes	Ctrl+T	Cmd+T
File: Save Script	Ctrl+Shift+S	Cmd+Shift+S
File: Close	Alt+F4	Cmd+Shift+W
Edit: Insert Row Before Selected	Insert	Alt+Up Arrow
Edit: Insert Row After Selected
Edit: Delete Row	Ctrl+Delete	Ctrl+Delete
Edit: Clone Selected Settings	Ctrl+Shift+V	Cmd+Shift+V
Edit: Highlight Current Column	Ctrl+Shift+K	Cmd+Shift+K
Edit: Highlight Current Row	Ctrl+Shift+R	Cmd+Shift+R
Edit: AutoFit Column Width	Ctrl+Alt+A	Cmd+Alt+A
Edit: Find	Ctrl+F	Cmd+F
Edit: Find Next	F3	Cmd+G
Edit: Find Previous	Shift+F3	Cmd+Shift+G
Edit: Find and Replace	Ctrl+H	Cmd+Shift+H
Edit: Fill Down	Ctrl+Alt+D	Cmd+Shift+D
Edit: Fill Right	Ctrl+Alt+R	Cmd+Shift+R
Edit: Fill Up
Edit: Fill Left
Edit: Clear Changes	Ctrl+Alt+Z	Cmd+Alt+Z
Edit: Clear Selected Deleted Row(s)	Ctrl+Alt+E	Cmd+Alt+E
Edit: Clear Cell Changes	Ctrl+Alt+Y	Cmd+Alt+Y
Edit: Set Cell to NULL	Delete	Delete
Edit: Insert Current Date/Time	Ctrl+Alt+T	Cmd+Alt+T
Edit: Insert Current Date Only	Ctrl+Shift+T	Cmd+Shift+T
Edit: Edit In Window	Ctrl+Alt+W	Cmd+Alt+W
Edit: Insert GUID	Ctrl+Alt+G	Cmd+Option+G
Window: Next Tab	Alt+Right	Ctrl+Right
Window: Previous Tab	Alt+Left	Ctrl+Left
Window: Focus Max Results	Ctrl+Alt+M	Cmd+Alt+M
Window: Show/Hide Preview Panel	Ctrl+Alt+F12	Fn+Ctrl+Alt+F12
General: Cancel	Ctrl+Alt+Backspace	Cmd+Alt+Backspace
History
Toolbar: Select	Ctrl+R	Cmd+R
Toolbar: Select & Close	Ctrl+Shift+R	Cmd+Shift+R
Toolbar: Clear Selected	Ctrl+D	Cmd+D
Toolbar: Clear All
Toolbar: Archive Selected
Toolbar: Archive All
Toolbar: Save Script	Ctrl+S	Cmd+S
Toolbar: Preview Panel	Ctrl+Alt+Shift+D	Fn+Ctrl+Alt+F12
Toolbar: Close	Alt+F4	Cmd+Shift+W
Toolbar: Copy Compare	Ctrl+Shift+D	Cmd+Shift+D
Toolbar: Find	Ctrl+F	Cmd+F
Toolbar: Find Next	F3	Cmd+G
Toolbar: Find Previous	Shift+F3	Cmd+Shift+G
General: Focus History/Preview	Ctrl+2	Ctrl+2
Explain Diagram
File: Save Image As	Ctrl+S	Cmd+S
File: Print	Ctrl+P	Cmd+P
File: Close	Alt+F4	Cmd+Shift+W
Edit: Zoom In	Ctrl+I	Cmd+I
Edit: Zoom Out	Ctrl+O	Cmd+O
Edit: Color Critical Path	Ctrl+Alt+F6	Fn+Cmd+Alt+F6
Edit: Color Critical Node	Ctrl+Alt+F7	Fn+Cmd+Alt+F7
Edit: Color Critical Operation	Ctrl+Alt+F8	Fn+Cmd+Alt+F8
Query Builder
File: New	Ctrl+N	Cmd+N
File: Open	Ctrl+O	Cmd+O
File: Save	Ctrl+S	Cmd+S
File: Save As	Ctrl+Shift+S	Cmd+Shift+S
File: Save SQL As	Ctrl+Alt+S	Cmd+Alt+S
File: Save Results	Ctrl+R	Cmd+R
File: Close	Alt+F4	Cmd+Shift+W
Edit: Copy SQL	Ctrl+C	Cmd+C
Query: Execute	Ctrl+E	Cmd+E
Query: Execute Edit	Ctrl+Alt+Enter	Cmd+Alt+Enter
Query: Cancel	Ctrl+Alt+Backspace	Cmd+Alt+Backspace
Query: Group By	Ctrl+G	Cmd+G
Query: Add Table	Insert	Insert
Windows: Diagram Pane	Ctrl+Alt+F9	Fn+Cmd+Alt+F9
Windows: Columns Pane	Ctrl+Alt+F10	Fn+Cmd+Alt+F10
Windows: SQL Pane	Ctrl+Alt+F11	Fn+Cmd+Alt+F11
Windows: Results Pane	Ctrl+Alt+F12	Fn+Cmd+Alt+F12
Windows: Next Pane	Alt+Right	Alt+Right
Windows: Previous Pane	Alt+Left	Ctrl+Left
Windows: Next Index	Alt+Page Up	Ctrl+Page Up
Windows: Previous Index	Alt+Page Down	Ctrl+Page Down
Windows: Clear Column Criteria	Ctrl+Alt+K	Cmd+Alt+K
Windows: Show Datatype
Windows: Show Index
Windows: Quick Criteria Mode
Windows: Limit Add Table to User Schema
Entity Relationship (ER) Modeler/Diagram
File: New	Ctrl+N	Cmd+N
File: Open	Ctrl+O	Cmd+O
File: Save	Ctrl+S	Cmd+S
File: Save As	Ctrl+Shift+S	Cmd+Shift+S
File: Print	Ctrl+P	Cmd+P
File: Close	Alt+F4	Cmd+Shift+W
Edit: Copy	Ctrl+C	Cmd+C
Edit: Paste	Ctrl+V	Cmd+V
Edit: Delete	Delete	Delete
Edit: Rename	F3	F3
Edit: Select All	Ctrl+A	Cmd+A
Edit: Auto-fit	Alt+A	Alt+A
Edit: Show/Hide
Edit: Properties
Edit: Find Table	Ctrl+G	Cmd+G
Edit: New Table	Alt+T	Alt+T
Edit: New View	Alt+V	Alt+V
Edit: New Note	Alt+N	Alt+N
Edit: New Relationship	Alt+F	Alt+F
Edit: New Subcategory	Alt+S	Alt+S
Edit: New Region	Alt+R	Alt+R
Edit: New Index	Alt+I	Alt+I
Edit: New Primary Key Constraint	Alt+P	Alt+P
Edit: New Unique Constraint	Alt+U	Alt+U
Edit: New Check Constraint	Alt+C	Alt+C
View: 1:1 Scale	Ctrl+1	Cmd+1
View: Zoom In	Ctrl+Equals	Cmd+Equals
View: Zoom Out	Ctrl+Minus	Cmd+Minus
View: Fit to Width	Ctrl+0	Cmd+0
Sheet: Add	Ctrl+Alt+T	Cmd+Alt+T
Sheet: Rename	Ctrl+Alt+R	Cmd+Alt+R
Sheet: Delete	Ctrl+Delete	Cmd+Fn+Delete
Tools: Save As Image	Ctrl+Shift+I	Cmd+Shift+I
Tools: Generate DDL Script	Ctrl+Shift+G	Cmd+Shift+G
Tools: Generate HTML Report	Ctrl+Shift+R	Cmd+Shift+R
Tools: Convert Model	Ctrl+Shift+C	Cmd+Shift+C
Display: Attribute Level	Ctrl+2	Cmd+2
Display: Primary Key Level	Ctrl+3	Cmd+3
Display: Entity Level	Ctrl+4	Cmd+4
Display: Physical Schema Level	Ctrl+5	Cmd+5
Display: Comments	Ctrl+6	Cmd+6
Display: Relationship Names	Ctrl+7	Cmd+7
Display: Schema Folder Grouping	Ctrl+8	Cmd+8
Display: Printing Grid
Display Nullable Columns	Ctrl+9	Cmd+9
Window: Show/Hide Model	Ctrl+Alt+F9	Fn+Ctrl+Alt+F9
Window: Show/Hide Object Properties	Ctrl+Alt+F10	Fn+Ctrl+Alt+F10
Window: Show/Hide Overview	Ctrl+Alt+F11	Fn+Ctrl+Alt+F11
Window: Show/Hide Palette	Ctrl+Alt+F12	Fn+Ctrl+Alt+F12
PDF Viewer
File: Save As	Ctrl+Shift+S	Cmd+Shift+S
File: Print	Ctrl+P	Cmd+P
File: Close	Alt+F4	Cmd+Shift+W
Edit: Copy Selected Text	Ctrl+C	Cmd+C
View: First Page
View: Previous Page
View: Next Page
View: Last Page
View: Go to Page
View: Zoom in
View: Zoom Out
View: Actual Size
View: Fit Height
View: Fit Width
View: Single Page
View: Continuous
View: Facing
View: Facing Continuous
View: Rotate Left
View: Rotate Right
Tools: Search	Ctrl+F	Cmd+F
Tools: Pan
Tools: Text Select
Tools: Zoom In
Tools: Zoom Out
Tools: Show/Hide Utility Pane
Compress Tool
File: New
File: Open
File: Close	Alt+F4	Cmd+Shift+W
Actions: Add File
Actions: Remove File
Actions: Extract
Actions: Extract to Archive
Actions: Encrypt

OS X keyboards use Function keys as special keys for the operating system as part of the default System Preferences(F1 reduce display brightness, F4 Launchpad, F10 mute sound, etc.). This setting can be changed under System Preferences > Keyboard and clicking the radio button next to "Use all F1, F2, etc. keys as standard function keys", so that the modifier key Fn does not have to be used for Aqua Data Studio keyboard shortcuts that require Function keys.