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

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

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

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

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

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

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

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 <\/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 column 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