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 |