title: How to rename a column in Databricks
body: <p>How do you rename a column in Databricks?</p>
  
  <p>The following does not work:</p>
  
  <pre><code>ALTER TABLE mySchema.myTable change COLUMN old_name new_name int
  </code></pre>
  
  <p>It returns the error:</p>
  
  <blockquote>
    <p>ALTER TABLE CHANGE COLUMN is not supported for changing column 'old_name' with type 'IntegerType >(nullable = true)' to 'new_name' with type 'IntegerType (nullable = true)';</p>
  </blockquote>
  
  <p>If it makes a difference, this table is using Delta Lake, and it is NOT partitioned or z-ordered by this "old_name" column.</p>