Convert query letters to uppercase using Management Studio

11,552

Select all of your query. Then go to Edit > Advanced > Make Uppercase or simply hit Ctrl+Shift+U to make the query uppercase.
Please note that it will make everything uppercase. (i.e., table names, fields name, strings etc.)

EDIT:
If you are able to install add-ins, you can also use SSMS Tools Packs to uppercase only the keywords.

Share:
11,552
Mark13426
Author by

Mark13426

Updated on July 29, 2022

Comments

  • Mark13426
    Mark13426 almost 2 years

    Can I convert query syntax to uppercase using SQL Server Management Studio? I have a bunch of queries that are all written in lowercase letters, and I want to convert them all to uppercase letters. I'm looking for a built-in editor functionality.

  • nam
    nam over 2 years
    Thank you for sharing your thoughts (my upvote). You may want to slightly change your note "Please note that ...." to "Please note that if you make the change using Edit > Advanced > Make Uppercase then it will make everything uppercase (i.e., table names, fields name, strings etc.)". But using Ctrl+Shift+U will make changes only to the query syntax you selected - and hence, it's a safer option.