Upper case or lower case alias name in SQL statement

Unlike some other SQL formatting tools, SQL Pretty Printer able to control the case of alias name in SQL statement, this feature helps you to find out alias in SQL statement quickly.

name: case_alias_name, default is no change.

setting path: capitalisation -> Alias


SELECT departmentname,

       Min(salary) AS min_salary

FROM   employees

GROUP  BY departmentname 

After setting case_alias_name to upper case,


SELECT departmentname,

       Min(salary) AS MIN_SALARY

FROM   employees

GROUP  BY departmentname 

Newsletter Updates

Enter your email address below to subscribe to our newsletter