HeidiSQL keyboard shortcuts

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

HeidiSQL
Ctrl + N

New window

Ctrl + T

New query tab

Ctrl + F4

Close query tab

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

Advertisement
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

Del

Delete all rows in selected table(s)

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

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 +

Previous result tab

Alt +

Next result tab

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


Share this page on:

Program information

Program name: 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: https://www.heidisql.com


Similar programs


  1. Fortnite (PC)Fortnite (PC)
    15158    2
  2. SketchUpSketchUp
    11273   
  3. PlayerUnknown's BattlegPlayerUnknown's Battleg
    8649    2
  4. Total CommanderTotal Commander
    6535   
  5. AMD Radeon ReLiveAMD Radeon ReLive
    6502    2
  6. Notepad++Notepad++
    6230   
More keyboard shortcuts...

Advertisement

Advertisement

  Subscribe to our mailing list!

Useful technology tips and keyboard shortcuts will appear in your inbox.

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

What is your favorite HeidiSQL hotkey? Do you have any useful tips for program? Let other users know below.