ApexSQL Knowledgebase: How to automatically change the case of SQL keywords into uppercase when they are typed in a Query Editor window?

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly.

FAQs

Quick answers to common questions.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools.

Online Documentation

All of our help files for download or convenient viewing online.

Videos

Watch product demos, training videos, or tutorials of our products' main features.

ApexSQL Knowledgebase

Tips and How-to Articles for Apex SQL Tools

How to automatically change the case of SQL keywords into uppercase when they are typed in a Query Editor window?

DESCRIPTION
This article describes how to configure ApexSQL Edit to automatically change the case of SQL keywords in SQL statements to uppercase without using the reformatting feature.

SOLUTION
It is possible to configure ApexSQL Edit to change automatically SQL keywords typed in a Query Editor window into uppercase. Just press the Ctrl+Shift+S keyboard shortcut to display the All Settings dialog box.
Find the UpperCaseReservedWords setting (you can filter all settings by typing the text ‘*Upper*’ in the filter row of this dialog box, like displayed on the screen shot below) and change its value to True.

From now on, all your SQL keywords will be changed to uppercase after they are typed in a Query Editor window and after the Enter key is pressed at the end of the line, like displayed on the screen shots below:

SQL keywords before pressing the Enter key:

SQL keywords after pressing the Enter key:

Note: You can also change the case of the whole text typed in a Query Editor window to uppercase, lowercase and ‘proper’ case using the Ctrl+U keyboard shortcut. This keyboard shortcut can be applied to comments included into your SQL scripts or to scripts themselves, if your database is not case sensitive.
Just select the text you want to change and press Ctrl+U:

The marked text will be changed to uppercase.

Press the U key again holding down the Ctrl key and the text will be changed to lowercase:

Press the U key again holding down the Ctrl key and the text will be changed to ‘proper’ case:

The Ctrl+U keyboard shortcut works in a round robin way.

SEE ALSO
ApexSQL Refactor
ApexSQL Edit Help - Formatting options

AUTHOR
Anna Lesniak

LAST REVIEW DATE
15 June 2009

Labels: Apex SQL Edit

posted by Anna Lesniak on Monday, June 08, 2009

0 Comments: