How to use default shortcuts and assign custom shortcuts to commands in SSMS

In SQL Server Management Studio (SSMS), 3 frequently used stored procedures are already assigned to shortcut keys by default:

Alt+F1 – sp_help
Ctrl+1 – sp_who
Ctrl+2 – sp_lock

ssms default keyboard shortcut

If you want to execute sp_help on the Production.Product table, type 'Production.Product', highlight it, and hit Alt-F1:

sp_help keyboard shortcut on a table

To execute sp_help on the AdventureWorks database, open new query window, select a database from the drop-down menu, and hit Alt-F1:

sp_help keyboard shortcut on a database

To execute sp_who using default keyboard shortcut, open new query window, and hit Ctrl+1:

sp_who keyboard shortcut

To execute sp_lock using default keyboard shortcut, open new query window, and hit Ctrl+2:

sp_lock keyboard shortcut

In SQL Server Management Studio (SSMS), you can configure your own keyboard shortcut:
Go to Tools -> Options -> Environment -> Keyboard
Assign a T-SQL statement to the keyboard shortcut (for example SELECT TOP 10 * FROM if you use this command a lot):

ssms keyboard shortcut setup

Changes will take effect only in query windows that are opened after the change.

Open a new query window in SSMS, type a table name, highlight the table name and hit the new keyboard shortcut:

ssms keyboard shortcut result

In this example, it will execute the query:
SELECT TOP 10 * FROM Production.Product