HeidiSQL Keyboard Shortcuts:
HeidiSQL is open-source software. It is designed for web developers. It allows you to create and edit tables, edit data, procedures, and scheduled events. In this article, we have listed the shortcut keys for HeidiSQL. Make use of it.
Last Updated On Aug 3, 2020.
Download HeidiSQL Keyboard Shortcut keys for Offline Study Here: HeidiSQL Shortcuts.PDF
File Shortcuts:
| Shortcut |
Function |
| CTRL+N |
It will Open New window |
| CTRL+T |
Open New query tab |
| CTRL+F4 |
Used to Close query tab |
Various Shortcuts:
| Shortcut |
Function |
| CTRL+C |
Copy |
| CTRL+V |
Paste from clipboard |
| CTRL+X |
Cut |
| Alt+Backspace |
Undo |
| CTRL+P |
Print |
| F5 |
Refresh |
| F5 |
Full status refresh. Get full statistics refresh on table data |
| CTRL+A |
Used to Select all items or text |
| CTRL+I |
It is Used for Invert selection |
| CTRL+Alt+F |
Used to Activate filter panel |
| Esc |
This Shortcut will Cancel running operation |
| CTRL+S |
Used to Save as text file |
| CTRL+D |
It will Show Database tree |
| CTRL+E |
Table filter |
| CTRL+1 |
Used to Go to tab 1 |
| CTRL+2 |
It is Used to Go to tab 2 |
| CTRL+3 |
Used to Go to tab 3 |
| CTRL+4 |
It is Used to Go to tab 4 |
| CTRL+5 |
Used to Go to tab 5 |
| CTRL+Shift+C |
This Shortcut will Copy selected rows in the custom format |
| Shortcut |
Function |
| CTRL+Shift+F |
Used to Search selected tables for text occurrences |
| F1 |
Open SQL help browser |
| CTRL+Shift+Tab |
Used to Go back to the previous tab |
| CTRL+Tab |
It is Used to Go to next tab |
Database Shortcut:
| Shortcut |
Function |
| Del |
This Shortcut Deletes all rows in the selected table |
SQL Shortcuts:
| Shortcut |
Function |
| F9 |
It will Execute SQL query |
| CTRL+f9 |
Used to Execute selected SQL |
| CTRL+Shift+F9 |
It will Run currently focused SQL query |
| CTRL+O |
Used to Load SQL file |
| F12 |
Used to Save SQL to a text file |
| CTRL+Shift+S |
It will Save selected text to a file |
| CTRL+W |
Helps to Clear query editor |
| CTRL+F |
Used to Find text |
| CTRL+R |
It will Replace text |
| F3 |
Used to Find or replace again |
| CTRL+S |
This Shortcut will Save SQL to file |
| CTRL+F8 |
It will Automatically reformat disordered SQL in the active editor to make it more readable |
Data Shortcuts:
| Shortcut |
Function |
| Insert |
Used to Insert row |
| CTRL+Insert |
This Shortcut is Used to Duplicate row |
| CTRL+Del |
Used to Delete selected row |
| CTRL+Enter |
Post |
| Esc |
It will Cancel editing |
| CTRL+W |
Used to Clear filter editor |
| F9 |
This Shortcut is Used to Apply filter |
| Alt+S |
Used to Reset sorting |
| CTRL+Alt+PgDn |
It will Show next 1.000 rows |
| CTRL+Alt+End |
Used to Show all rows |
| CTRL+Shift+N |
This Shortcut will Set focused cell to NULL |
| CTRL+F2 |
Used to Insert SQL function call in this grid cell. For Example – NOW() |
| Alt+← |
It will Move to Previous result tab |
| Alt+→ |
Go to the Next result tab |
SQL Editing Shortcuts:
I hope, this article helped you to know all the shortcut keys for HeidiSQL. Kindly, drop your suggestions in the below comment section.