Keyboard Shortcut keys for HeidiSQL!!

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+V Paste from clipboard
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

Tools Shortcuts:

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:

Shortcut Function
CTRL+N Used to Insert line
CTRL+T It will Delete word
CTRL+Y It is Used to Delete line
CTRL+Shift+Y Used to Delete EOL
CTRL+Shift+Z Redo
CTRL+0 Go to marker 0…9
CTRL+Shift+0 Used to Set marker 0…0
CTRL+Shift+N It is Used for Normal selection
CTRL+Shift+C Used for Column selection
CTRL+Shift+L It is Used for Line selection
CTRL+Shift+B This Shortcut will Match bracket
CTRL+U Enable Uppercase block
CTRL+L Enable Lowercase block

I hope, this article helped you to know all the shortcut keys for HeidiSQL. Kindly, drop your suggestions in the below comment section.

Leave a Comment