Custom Keyboard Shortcuts in SQL Server Management Studio (SSMS)

You might not be aware that you can create your own keyboard shortcuts in SSMS. Which is handy when you have some SQL but want to perform a quick action without typing it out, for example inspecting tables like below.

Example

So in the below example I’ve highlighted my table and hit Ctrl + 3 and its returned the first 100 rows from the Purchasing.Suppliers table.

How To Add Shortcuts

In SSMS go to Tools > Options.

SSMS > Tools > Options…

In the Options pane expand Keyboard and select Query Shortcuts.

Options > Keyboard > Query Shortcuts

Enjoy!