===========================
HeidiSQL keyboard shortcuts
===========================

First published at 9/2/2017 on https://defkey.com/heidisql-shortcuts

HeidiSQL is a tool designed for web developers using MySQL server,
Microsoft SQL databases and PostgreSQL. It allows you to browse and edit
data, create and edit tables, views, procedures, triggers and more.

HeidiSQL has 68 shortcuts and we have listed all of them below.



File
----

Ctrl + N                New window
Ctrl + T                New query tab
Ctrl + F4               Close query tab


Various shortcuts
-----------------

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                Select all items or text
Ctrl + I                Invert selection
Ctrl + Alt + F          Activate filter panel
Esc                     Cancel running operation
Ctrl + S                Save as text file
Ctrl + D                Database tree
Ctrl + E                Table filter
Ctrl + 1                Go to tab 1
Ctrl + 2                Go to tab 2
Ctrl + 3                Go to tab 3
Ctrl + 4                Go to tab 4
Ctrl + 5                Go to tab 5
Ctrl + Shift + C        Copy selected rows in custom format


Tools
-----

Ctrl + Shift + F        Search selected tables for text occurences
F1                      SQL help browser
Ctrl + Shift + Tab      Go back to previous tab
Ctrl + Tab              Go to next tab


Database
--------

Del                     Delete all rows in selected table(s)


SQL
---

F9                      Execute SQL query
Ctrl + F9               Execute selected SQL
Ctrl + Shift + F9       Run currently focused SQL query
Ctrl + O                Load SQL file
F12                     Save SQL to a text file
Ctrl + Shift + S        Save selected text to a file
Ctrl + W                Clear query editor
Ctrl + F                Find text
Ctrl + R                Replace text
F3                      Find or replace again
Ctrl + S                Save SQL to file
Ctrl + F8               Automatically reformat disordered SQL in active editor to make it more
readable


Data
----

Insert                  Insert row
Ctrl + Insert           Duplicate row
Ctrl + Del              Delete selected row(s)
Ctrl + Enter            Post
Esc                     Cancel editing
Ctrl + W                Clear filter editor
F9                      Apply filter
Alt + S                 Reset sorting
Ctrl + Alt + Page Down  Show next 1.000 rows
Ctrl + Alt + End        Show all rows
Ctrl + Shift + N        Set focused cell to NULL
Ctrl + F2               Insert SQL function call in this grid cell. E.g. NOW()
Alt + Left arrow        Previous result tab
Alt + Right arrow       Next result tab


SQL editing
-----------

Ctrl + N                Insert line
Ctrl + T                Delete word
Ctrl + Y                Delete line
Ctrl + Shift + Y        Delete E O L
Ctrl + Z                Undo
Ctrl + Shift + Z        Redo
Ctrl + 0                Goto marker 0...9
Ctrl + Shift + 0        Set marker 0...0
Ctrl + Shift + N        Normal select
Ctrl + Shift + C        Column select
Ctrl + Shift + L        Line select
Ctrl + Shift + B        Match bracket
Ctrl + U                Uppercase block
Ctrl + L                Lowercase block

Last modified on (UTC): Thursday, January 30, 2020
Defkey © All rights reserved.