HeidiSQL keyboard shortcuts

HeidiSQL

defkey.com -
4 years ago
- Shortcuts

If you frequently browse or edit databases using HeidiSQL, you may want to take advantage of these useful keyboard shortcuts.

0
Ctrl + N

New window

0
Ctrl + T

New query tab

0
Ctrl + F4

Close query tab

0
Ctrl + C

Copy

0
Ctrl + V

Paste from clipboard

0
Ctrl + X

Cut

2
Alt + Backspace

Undo

0
Ctrl + P

Print

0
F5

Refresh

0
F5

Full status refresh. Get full statistics refresh on table data

0
Ctrl + A

Select all items or text

0
Ctrl + I

Invert selection

0
Ctrl + Alt + F

Activate filter panel

0
Esc

Cancel running operation

0
Ctrl + S

Save as text file

0
Ctrl + D

Database tree

0
Ctrl + E

Table filter

0
Ctrl + 1

Go to tab 1

0
Ctrl + 2

Go to tab 2

0
Ctrl + 3

Go to tab 3

0
Ctrl + 4

Go to tab 4

0
Ctrl + 5

Go to tab 5

0
Ctrl + ↑   Shift + C

Copy selected rows in custom format

0
Ctrl + ↑   Shift + F

Search selected tables for text occurences

0
F1

SQL help browser

0
Ctrl + ↑   Shift + Tab

Go back to previous tab

0
Ctrl + Tab

Go to next tab

0
Del

Delete all rows in selected table(s)

0
F9

Execute SQL query

1
Ctrl + F9

Execute selected SQL

0
Ctrl + ↑   Shift + F9

Run currently focused SQL query

0
Ctrl + O

Load SQL file

0
F12

Save SQL to a text file

0
Ctrl + ↑   Shift + S

Save selected text to a file

0
Ctrl + W

Clear query editor

0
Ctrl + F

Find text

0
Ctrl + R

Replace text

0
F3

Find or replace again

0
Ctrl + S

Save SQL to file

0
Ctrl + F8

Automatically reformat disordered SQL in active editor to make it more readable

0
Insert

Insert row

0
Ctrl + Insert

Duplicate row

0
Ctrl + Del

Delete selected row(s)

0
Ctrl + ⤶ Enter

Post

0
Esc

Cancel editing

0
Ctrl + W

Clear filter editor

0
F9

Apply filter

0
Alt + S

Reset sorting

0
Ctrl + Alt + Page Down

Show next 1.000 rows

0
Ctrl + Alt + End

Show all rows

0
Ctrl + ↑   Shift + N

Set focused cell to NULL

0
Ctrl + F2

Insert SQL function call in this grid cell. E.g. NOW()

0
Alt +

Previous result tab

0
Alt +

Next result tab

0
Ctrl + N

Insert line

0
Ctrl + T

Delete word

0
Ctrl + Y

Delete line

0
Ctrl + ↑   Shift + Y

Delete E O L

0
Ctrl + Z

Undo

0
Ctrl + ↑   Shift + Z

Redo

0
Ctrl + 0

Goto marker 0...9

0
Ctrl + ↑   Shift + 0

Set marker 0...0

0
Ctrl + ↑   Shift + N

Normal select

0
Ctrl + ↑   Shift + C

Column select

0
Ctrl + ↑   Shift + L

Line select

0
Ctrl + ↑   Shift + B

Match bracket

0
Ctrl + U

Uppercase block

0
Ctrl + L

Lowercase block


Share this page on:

Program information

Program name: HeidiSQL HeidiSQL (Developer tools)

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.

Web page: heidisql.com

Last update: 30 January 2020

How easy to press shortcuts: 85%

More information >>

Shortcut count: 68

Platform detected: Windows or Linux (not macOS)

Similar programs



Advertisement

Join our mailing list!

Your email is kept private and we don't spam.

Guest says: 3 months ago 2/17/2021 10:07 PM
What's the shortcut for commenting a line of code in the query editor?

Zeynel Abidin Öztürk Admin says in reply to defkey.com : 3 months ago 2/17/2021 10:18 PM
In my version it's not assigned. I see a shortcut can be assigned for comment/uncomment in Preferences > Shortcuts tab > SQL > Un/comment