Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# Upper case or lower case alias name in SQL statement

- admin
- October 4, 2011
- format option, sql pretty printer, v238

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

I accept the Privacy Policy

### Related Posts

#### NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.3

- September 19, 2012

#### NEW RELEASE: SQL PRETTY PRINTER VERSION 3.3.2

- July 18, 2012

#### SQL Pretty Printer works when Multi-SSMS installed

- July 5, 2012