{"id":641,"date":"2010-11-29T23:01:35","date_gmt":"2010-11-30T04:01:35","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=641"},"modified":"2011-09-26T21:43:48","modified_gmt":"2011-09-27T02:43:48","slug":"sql-refactor-rename-column-and-table","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/","title":{"rendered":"SQL Refactor: rename column and table"},"content":{"rendered":"<p>We begin to introduce features of SQL Refactor since Version 3.2.0.<br \/>\nThe first feature we added in Version3.2.0 is rename column and table of SQL script.<\/p>\n<p>SQL Pretty Printer is able to rename column and table in complex SQL including nested subquery, joins, parameters in function call, stored procedures and anywhere in the SQL script.<\/p>\n<p>Usually, search and replace functions in the most modern editors can&#8217;t do this job well. Take the following SQL for example:<\/p>\n<pre>\r\nSELECT Persons.Name, Orders.Name\r\nFROM Persons\r\nLEFT JOIN Orders\r\nON Persons.P_Id=Orders.P_Id\r\nORDER BY Persons.Name\r\n<\/pre>\n<p>If you want to rename column Persons.Name to Persons.firstName, By using replace function in editor will replace all Name in this SQL script that also including Orders.Name which is incorrect.<\/p>\n<p>By using rename column feature in SQL Pretty Printer, it will be much easy and safe to rename Persons.Name in the select list and order by clause to Persons.firstName while leaving Orders.Name untouched.<\/p>\n<p><a href=\"http:\/\/www.dpriver.com\/dlaction.php\">Have a try of SQL Pretty Printer Now<\/a><\/p>\n<p>Screen shots of this awesome features<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.dpriver.com\/images\/screenshots\/v320\/sqlrefactor_rename_column_table_menu.png\" alt=\"SQL refactor: rename column and table name\" \/><\/p>\n<p>Rename column name<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.dpriver.com\/images\/screenshots\/v320\/sqlrefactor_rename_column_table_1.png\" alt=\"SQL refactor: rename column and table name\" \/><\/p>\n<p>After rename column name<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.dpriver.com\/images\/screenshots\/v320\/sqlrefactor_rename_column_table_2.png\" alt=\"SQL refactor: rename column and table name\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We begin to introduce features of SQL Refactor since Version 3.2.0. The first feature we added in Version3.2.0 is rename column and table of SQL script. SQL Pretty Printer is able to rename column and table in complex SQL including nested subquery, joins, parameters in function call, stored procedures and anywhere in the SQL script. Usually, search and replace functions in the most modern editors can&#8217;t do this job well. Take the following SQL for example: SELECT Persons.Name, Orders.Name FROM Persons LEFT JOIN Orders ON Persons.P_Id=Orders.P_Id ORDER BY Persons.Name If you want to rename column Persons.Name to Persons.firstName, By using\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[24],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Refactor: rename column and table<\/title>\n<meta name=\"description\" content=\"SQL Refactor: rename column and table\" \/>\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\/2010\/11\/sql-refactor-rename-column-and-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Refactor: rename column and table\" \/>\n<meta property=\"og:description\" content=\"SQL Refactor: rename column and table\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2010-11-30T04:01:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-09-27T02:43:48+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dpriver.com\/images\/screenshots\/v320\/sqlrefactor_rename_column_table_menu.png\" \/>\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\/2010\/11\/sql-refactor-rename-column-and-table\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/\",\"name\":\"SQL Refactor: rename column and table\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2010-11-30T04:01:35+00:00\",\"dateModified\":\"2011-09-27T02:43:48+00:00\",\"description\":\"SQL Refactor: rename column and table\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Refactor: rename column and table\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\"},\"headline\":\"SQL Refactor: rename column and table\",\"datePublished\":\"2010-11-30T04:01:35+00:00\",\"dateModified\":\"2011-09-27T02:43:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/\"},\"wordCount\":171,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"articleSection\":[\"sql pretty printer\"],\"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":"SQL Refactor: rename column and table","description":"SQL Refactor: rename column and table","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\/2010\/11\/sql-refactor-rename-column-and-table\/","og_locale":"en_US","og_type":"article","og_title":"SQL Refactor: rename column and table","og_description":"SQL Refactor: rename column and table","og_url":"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/","og_site_name":"SQL and Data Blog","article_published_time":"2010-11-30T04:01:35+00:00","article_modified_time":"2011-09-27T02:43:48+00:00","og_image":[{"url":"http:\/\/www.dpriver.com\/images\/screenshots\/v320\/sqlrefactor_rename_column_table_menu.png"}],"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\/2010\/11\/sql-refactor-rename-column-and-table\/","url":"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/","name":"SQL Refactor: rename column and table","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2010-11-30T04:01:35+00:00","dateModified":"2011-09-27T02:43:48+00:00","description":"SQL Refactor: rename column and table","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Refactor: rename column and table"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/"},"author":{"name":"admin","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7"},"headline":"SQL Refactor: rename column and table","datePublished":"2010-11-30T04:01:35+00:00","dateModified":"2011-09-27T02:43:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/2010\/11\/sql-refactor-rename-column-and-table\/"},"wordCount":171,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"articleSection":["sql pretty printer"],"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\/641"}],"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=641"}],"version-history":[{"count":11,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/641\/revisions"}],"predecessor-version":[{"id":1011,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/641\/revisions\/1011"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}