DATA EDITOR

Submit changes Ctrl+Enter

Revert changes Ctrl+Alt+Z
Value completion Ctrl+Space

Find any action Text search Ctrl+F

Ctrl+Shift+A
inside the IDE Go to related data F4
Go to referencing data Alt+F7
Quick cell/row view Ctrl+Q
MAIN
Maximize cell view Shift+Enter
Execute statement Ctrl+Enter
Column list Ctrl+F12
Generate SQL for object Ctrl+Alt+G
Select row Shift+Space
Code completion Ctrl+Space
Go to declaration Ctrl+B or Ctrl+Click
NAVIGATION
Rename Shift+F6
Go to:
Recent files/consoles popup Ctrl+E
Table/procedure, etc. Ctrl+N
Show only editor Ctrl+Shift+F12
Any object Ctrl+Alt+Shift+N
Full-text search in a database Shift+Ctrl+Alt+F
File Ctrl+Shift+N
Return focus to editor Esc
SQL EDITOR
Show:
Generate code
Alt+Insert
(Tables, functions, procedures) Database explorer Alt+1
Show intention actions and quick-fixes Alt+Enter File structure popup Ctrl+F12
Parameter info Current file or object in any view Alt+F1
Ctrl+P
(within method call arguments)
Recent locations Ctrl+Shift+E
Column names info (within VALUES clause) Ctrl+P
Ctrl+Alt+Left /
Go back / forward
Current line or selected block: Ctrl+Alt+Right
Duplicate Ctrl + D Jump to table’s data F4
Delete Ctrl + Y Jump to DDL Ctrl+B
Cut to clipboard Ctrl + X Modify object Ctrl+F6
Copy to clipboard Ctrl + C
Paste from recent buffers Ctrl + Shift + V SEARCH/REPLACE

Place multicarets Alt+Shift+Click Find / Replace Ctrl+F / Ctrl+R

Place / delete another caret Ctrl+Shift+F /

Alt+J / Alt+Shift+J Find / Replace in path
to the next occurrence Ctrl+Shift+R

Increase or decrease Find usages Alt+F7

Ctrl+W / Ctrl+Shift+W
syntax-aware selection Show usages Ctrl+Alt+F7
Reformat code Ctrl+Alt+L Search everywhere Double Shift
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 @DataGrip
8429

Close active console/editor tab Ctrl + F4 jetbrains.com/datagrip

 DATA EDITOR
Submit changes Cmd+Enter
Revert changes Cmd+Alt+Z
Value completion Cmd+Space

Find any action Text search Cmd+F

Shift+Cmd+A
inside the IDE Go to related data Cmd+Down
Go to referencing data Alt+F7
Quick cell/row view F1
MAIN
Maximize cell view Shift+Enter
Execute statement Cmd+Enter
Column list Cmd+F12
Generate SQL for object Cmd+Alt+G
Select row Shift+Space
Code completion Ctrl+Space
Go to declaration Cmd+B or Cmd+Click
NAVIGATION
Rename Shift+F6
Go to:
Recent files/consoles popup Cmd+E
Table/procedure, etc. Cmd+O
Show only editor Shift+Cmd+F12
Any object Alt+Cmd+O
Full-text search in a database Shift+Cmd+ Alt+F
File Shift+Cmd+O
Return focus to editor Esc
SQL EDITOR
Show:
Generate code
Cmd+N
(Tables, functions, procedures) Database explorer Cmd+1
Show intention actions and quick-fixes Alt+Enter File structure popup Cmd+F12
Parameter info Current file or object in any view Alt+F1
Cmd+P
(within method call arguments)
Recent locations Cmd+Shift+E
Column names info (within VALUES clause) Cmd+P
Go back / forward Cmd+[ / Cmd+]
Current line or selected block:
Jump to table’s data F4
Duplicate Cmd+D
Jump to DDL Cmd+B
Delete Cmd+Delete
Modify object Cmd+F6
Cut to clipboard Cmd+X
Copy to clipboard Cmd+C SEARCH/REPLACE
Paste from recent buffers Shift+Cmd+V Find / Replace Cmd+F / Cmd+R
Place multicarets Alt+Shift+Click Shift+Cmd+F /
Find / Replace in path
Place / delete another caret Ctrl+G / Shift+Cmd+R
to the next occurrence Ctrl+Shift+G Find usages Alt+F7
Increase or decrease Show usages Alt+Cmd+F7
Alt+Up / Alt+Down
syntax-aware selection
Search everywhere Double Shift
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 @DataGrip
8429

Close active console/editor tab Cmd+W jetbrains.com/datagrip