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

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

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

setting path: capitalisation -> Table<\/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_table_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 table name in SQL statement, this feature helps you to find out tables in SQL statement quickly. name: case_table_name, default is no change. setting path: capitalisation -> Table SELECT department_id, Min(salary) FROM employees GROUP BY department_id After setting case_table_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 table 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