{"id":1221,"date":"2011-10-04T03:06:50","date_gmt":"2011-10-04T08:06:50","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1221"},"modified":"2011-10-14T21:03:58","modified_gmt":"2011-10-15T02:03:58","slug":"upper-case-or-lower-case-alias-name-in-sql-statement","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-alias-name-in-sql-statement\/","title":{"rendered":"Upper case or lower case alias name in SQL statement"},"content":{"rendered":"

Unlike some other SQL formatting tools, SQL Pretty Printer<\/a> able to control the case of alias name in SQL statement, this feature helps you to find out alias in SQL statement quickly.<\/p>\n

name: case_alias_name, default is no change.<\/p>\n

setting path: capitalisation -> Alias<\/p>\n

\nSELECT<\/span> departmentname<\/span>,<\/span>
\n
Min<\/span>(<\/span>salary<\/span>)<\/span> AS<\/span> min_salary<\/span>
\n
FROM<\/span> employees<\/span>
\n
GROUP<\/span> BY<\/span> departmentname<\/span>
\n<\/span><\/div>\n

After setting case_alias_name to upper case,<\/p>\n

\nSELECT<\/span> departmentname<\/span>,<\/span>
\n
Min<\/span>(<\/span>salary<\/span>)<\/span> AS<\/span> MIN_SALARY<\/span>
\n
FROM<\/span> employees<\/span>
\n
GROUP<\/span> BY<\/span> departmentname<\/span>
\n<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

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 <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18,24,22],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nUpper case or lower case alias name in SQL statement<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n