{"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<meta name=\"description\" content=\"Upper case or lower case column name in SQL statement\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upper case or lower case column name in SQL statement\" \/>\n<meta property=\"og:description\" content=\"Upper case or lower case column name in SQL statement\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-04T08:02:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-10-15T02:04:27+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\",\"name\":\"SQL and Data Blog\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"contentUrl\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"width\":251,\"height\":72,\"caption\":\"SQL and Data Blog\"},\"image\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"name\":\"SQL and Data Blog\",\"description\":\"SQL related blog for database professional\",\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/\",\"name\":\"Upper case or lower case column name in SQL statement\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2011-10-04T08:02:53+00:00\",\"dateModified\":\"2011-10-15T02:04:27+00:00\",\"description\":\"Upper case or lower case column name in SQL statement\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upper case or lower case column name in SQL statement\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\"},\"headline\":\"Upper case or lower case column name in SQL statement\",\"datePublished\":\"2011-10-04T08:02:53+00:00\",\"dateModified\":\"2011-10-15T02:04:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/\"},\"wordCount\":115,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"articleSection\":[\"format option\",\"sql pretty printer\",\"v238\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upper case or lower case column name in SQL statement","description":"Upper case or lower case column name in SQL statement","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/","og_locale":"en_US","og_type":"article","og_title":"Upper case or lower case column name in SQL statement","og_description":"Upper case or lower case column name in SQL statement","og_url":"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/","og_site_name":"SQL and Data Blog","article_published_time":"2011-10-04T08:02:53+00:00","article_modified_time":"2011-10-15T02:04:27+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.dpriver.com\/blog\/#organization","name":"SQL and Data Blog","url":"https:\/\/www.dpriver.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","contentUrl":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","width":251,"height":72,"caption":"SQL and Data Blog"},"image":{"@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.dpriver.com\/blog\/#website","url":"https:\/\/www.dpriver.com\/blog\/","name":"SQL and Data Blog","description":"SQL related blog for database professional","publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/","url":"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/","name":"Upper case or lower case column name in SQL statement","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2011-10-04T08:02:53+00:00","dateModified":"2011-10-15T02:04:27+00:00","description":"Upper case or lower case column name in SQL statement","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Upper case or lower case column name in SQL statement"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/"},"author":{"name":"admin","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7"},"headline":"Upper case or lower case column name in SQL statement","datePublished":"2011-10-04T08:02:53+00:00","dateModified":"2011-10-15T02:04:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/2011\/10\/upper-case-or-lower-case-column-name-in-sql-statement\/"},"wordCount":115,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"articleSection":["format option","sql pretty printer","v238"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.dpriver.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1219"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=1219"}],"version-history":[{"count":2,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1219\/revisions"}],"predecessor-version":[{"id":1254,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1219\/revisions\/1254"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=1219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=1219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}