All hotkeys for HeidiSQL
SQL editingInsert line |
Ctrl + N |
SQL editingDelete word |
Ctrl + T |
FileClose query tab |
Ctrl + F4 |
Various shortcutsCopy |
Ctrl + C |
Various shortcutsPaste from clipboard |
Ctrl + V |
Various shortcutsCut |
Ctrl + X |
Various shortcutsUndo |
Alt + ⬅ Backspace |
Various shortcuts |
Ctrl + P |
Various shortcutsFull status refresh. Get full statistics refresh on table data |
F5 |
Various shortcutsSelect all items or text |
Ctrl + A |
Various shortcutsInvert selection |
Ctrl + I |
Various shortcutsActivate filter panel |
Ctrl + Alt + F |
DataCancel editing |
Esc |
SQLSave SQL to file |
Ctrl + S |
Various shortcutsDatabase tree |
Ctrl + D |
Various shortcutsTable filter |
Ctrl + E |
Various shortcutsGo to tab 1 |
Ctrl + 1 |
Various shortcutsGo to tab 2 |
Ctrl + 2 |
Various shortcutsGo to tab 3 |
Ctrl + 3 |
Various shortcutsGo to tab 4 |
Ctrl + 4 |
Various shortcutsGo to tab 5 |
Ctrl + 5 |
SQL editingColumn select |
Ctrl + ↑ Shift + C |
ToolsSearch selected tables for text occurences |
Ctrl + ↑ Shift + F |
ToolsSQL help browser |
F1 |
ToolsGo back to previous tab |
Ctrl + ↑ Shift + ⭾ Tab |
ToolsGo to next tab |
Ctrl + ⭾ Tab |
DatabaseDelete all rows in selected table(s) |
Del |
DataApply filter |
F9 |
SQLExecute selected SQL |
Ctrl + F9 |
SQLRun currently focused SQL query |
Ctrl + ↑ Shift + F9 |
SQLLoad SQL file |
Ctrl + O |
SQLSave SQL to a text file |
F12 |
SQLSave selected text to a file |
Ctrl + ↑ Shift + S |
DataClear filter editor |
Ctrl + W |
SQLFind text |
Ctrl + F |
SQLReplace text |
Ctrl + R |
SQLFind or replace again |
F3 |
SQLAutomatically reformat disordered SQL in active editor to make it more readable |
Ctrl + F8 |
DataInsert row |
Insert |
DataDuplicate row |
Ctrl + Insert |
DataDelete selected row(s) |
Ctrl + Del |
DataPost |
Ctrl + ⤶ Enter |
DataReset sorting |
Alt + S |
DataShow next 1.000 rows |
Ctrl + Alt + Page Down |
DataShow all rows |
Ctrl + Alt + End |
SQL editingNormal select |
Ctrl + ↑ Shift + N |
DataInsert SQL function call in this grid cell. E.g. NOW() |
Ctrl + F2 |
DataPrevious result tab |
Alt + ← |
DataNext result tab |
Alt + → |
SQL editingDelete line |
Ctrl + Y |
SQL editingDelete E O L |
Ctrl + ↑ Shift + Y |
SQL editingUndo |
Ctrl + Z |
SQL editingRedo |
Ctrl + ↑ Shift + Z |
SQL editingGoto marker 0...9 |
Ctrl + 0 |
SQL editingSet marker 0...0 |
Ctrl + ↑ Shift + 0 |
SQL editingLine select |
Ctrl + ↑ Shift + L |
SQL editingMatch bracket |
Ctrl + ↑ Shift + B |
SQL editingUppercase block |
Ctrl + U |
SQL editingLowercase block |
Ctrl + L |