| DATA EDITOR | |
|---|---|
| Submit changes | Ctrl+Enter |
| Revert changes | Ctrl+Alt+Z |
| Value completion | Ctrl+Space |
| Text search | Ctrl+F |
| Go to related data | F4 |
| Go to referencing data | Alt+F7 |
| Quick cell/row view | Ctrl+Q |
| Maximize cell view | Shift+Enter |
| Column list | Ctrl+F12 |
| Select row | Shift+Space |
| NAVIGATION | |
|---|---|
| Go to: | |
| Table/procedure, etc. | Ctrl+N |
| Any object | Ctrl+Alt+Shift+N |
| File | Ctrl+Shift+N |
| Return focus to editor | Esc |
| Show: | |
| Database explorer | Alt+1 |
| File structure popup | Ctrl+F12 |
| Current file or object in any view | Alt+F1 |
| Recent locations | Ctrl+Shift+E |
| Go back / forward | Ctrl+Alt+Left / Ctrl+Alt+Right |
| Jump to table’s data | F4 |
| Jump to DDL | Ctrl+B |
| Modify object | Ctrl+F6 |
| Find any action inside the IDE | Ctrl+Shift+A |
|---|---|
| MAIN | |
|---|---|
| Execute statement | Ctrl+Enter |
| Generate SQL for object | Ctrl+Alt+G |
| Code completion | Ctrl+Space |
| Go to declaration | Ctrl+B or Ctrl+Click |
| Rename | Shift+F6 |
| Recent files/consoles popup | Ctrl+E |
| Show only editor | Ctrl+Shift+F12 |
| Full-text search in a database | Shift+Ctrl+Alt+F |
| SEARCH/REPLACE | |
|---|---|
| Find / Replace | Ctrl+F / Ctrl+R |
| Find / Replace in path | Ctrl+Shift+F / Ctrl+Shift+R |
| Find usages | Alt+F7 |
| Show usages | Ctrl+Alt+F7 |
| Search everywhere | Double Shift |
| SQL EDITOR | |
|---|---|
| Generate code (Tables, functions, procedures) |
Alt+Insert |
| Show intention actions and quick-fixes | Alt+Enter |
| Parameter info (within method call arguments) |
Ctrl+P |
| Column names info (within VALUES clause) | Ctrl+P |
| Current line or selected block: | |
| Duplicate | Ctrl+ D |
| Delete | Ctrl+ Y |
| Cut to clipboard | Ctrl+ X |
| Copy to clipboard | Ctrl+ C |
| Paste from recent buffers | Ctrl+ Shift+ V |
| Place multicarets | Alt+Shift+Click |
| Place / delete another caret to the next occurrence | Alt+J / Alt+Shift+J |
| Increase or decrease syntax-aware selection | Ctrl+W / Ctrl+Shift+W |
| Reformat code | Ctrl+Alt+L |
| Join lines | Ctrl+ Shift+J |
| Start new line | Shift+Enter |
| Quick info lookup | Ctrl+Q |
| Comment/uncomment: | |
| With line comment | Ctrl+/ |
| With block comment | Ctrl+Shift+/ |
| Toggle case for word or selected block | Ctrl+ Shift+U |
| Close active console/editor tab | Ctrl+ F4 |
| DATA EDITOR | |
|---|---|
| Submit changes | Cmd+Enter |
| Revert changes | Cmd+Alt+Z |
| Value completion | Cmd+Space |
| Text search | Cmd+F |
| Go to related data | Cmd+Down |
| Go to referencing data | Alt+F7 |
| Quick cell/row view | F1 |
| Maximize cell view | Shift+Enter |
| Column list | Cmd+F12 |
| Select row | Shift+Space |
| NAVIGATION | |
|---|---|
| Go to: | |
| Table/procedure, etc. | Cmd+O |
| Any object | Alt+Cmd+O |
| File | Shift+Cmd+O |
| Return focus to editor | Esc |
| Show: | |
| Database explorer | Cmd+1 |
| File structure popup | Cmd+F12 |
| Current file or object in any view | Alt+F1 |
| Recent locations | Cmd+Shift+E |
| Go back / forward | Cmd+[ / Cmd+] |
| Jump to table’s data | F4 |
| Jump to DDL | Cmd+B |
| Modify object | Cmd+F6 |
| Find any action inside the IDE | Shift+Cmd+A |
|---|---|
| MAIN | |
|---|---|
| Execute statement | Cmd+Enter |
| Generate SQL for object | Cmd+Alt+G |
| Code completion | Ctrl+Space |
| Go to declaration | Cmd+B or Cmd+Click |
| Rename | Shift+F6 |
| Recent files/consoles popup | Cmd+E |
| Show only editor | Shift+Cmd+F12 |
| Full-text search in a database | Shift+Cmd+ Alt+F |
| SEARCH/REPLACE | |
|---|---|
| Find / Replace | Cmd+F / Cmd+R |
| Find / Replace in path | Shift+Cmd+F / Shift+Cmd+R |
| Find usages | Alt+F7 |
| Show usages | Alt+Cmd+F7 |
| Search everywhere | Double Shift |
| SQL EDITOR | |
|---|---|
| Generate code (Tables, functions, procedures) |
Cmd+N |
| Show intention actions and quick-fixes | Alt+Enter |
| Parameter info (within method call arguments) |
Cmd+P |
| Column names info (within VALUES clause) | Cmd+P |
| Current line or selected block: | |
| Duplicate | Cmd+D |
| Delete | Cmd+Delete |
| Cut to clipboard | Cmd+X |
| Copy to clipboard | Cmd+C |
| Paste from recent buffers | Shift+Cmd+V |
| Place multicarets | Alt+Shift+Click |
| Place / delete another caret to the next occurrence | Ctrl+G / Ctrl+Shift+G |
| Increase or decrease syntax-aware selection | Alt+Up / Alt+Down |
| Reformat code | Alt+Cmd+L |
| Join lines | Ctrl+Shift+J |
| Start new line | Shift+Enter |
| Quick info lookup | F1 |
| Comment/uncomment: | |
| With line comment | Cmd+/ |
| With block comment | Cmd+Shift+/ |
| Toggle case for word or selected block | Shift+Cmd+U |
| Close active console/editor tab | Cmd+W |
