Query shortcuts on SSMS 19

Question

I have recently upgraded to SSMS 19, After upgrading to it I have started facing difficulty in using custom query shortcuts. I tried to use Cntrl + 3 for select * from , But couldn't able to use it. could anyone please help me out on this

Answer 1

I tried to use Cntrl + 3 for select * from

That's not a default shortcut, but a user defined one. Have you imported your stting form old SSMS version?

Menu "Tools" => "Import/Export settings"

Answer 2

When you install a new major-number version of SSMS, you can opt to import the settings from the older version. However, far from all settings are imported. I find that I have go through the settings each time, and change those that were no imported.

I tested setting up a shortcut as you described in SSMS 19, and it worked. Note, though, that it only takes effect for new windows. Existing windows will not pick up the change.

Answer 3

Hi @Nikhil

Open SSMS, Go to Tools -> Options ->Environment -> Keyboard -> Query Shortcuts. And check if ctrl + 3 is defined as select * from.

Try open a new query window or restart SSMS.

Check if database or table name are selected correctly.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.