Upper case or lower case column name in SQL statement

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

name: case_column_name, default is no change.

setting path: capitalisation -> Column


SELECT department_id,

       Min(salary)

FROM   employees

GROUP  BY department_id 

After setting case_column_name to upper case,


SELECT DEPARTMENT_ID,

       Min(SALARY)

FROM   employees

GROUP  BY DEPARTMENT_ID 

Newsletter Updates

Enter your email address below to subscribe to our newsletter