title: How to drop a column from a Databricks Delta table?
body: <p>I have recently started discovering Databricks and faced a situation where I need to drop a certain column of a delta table. When I worked with PostgreSQL it was as easy as </p>
  
  <pre><code>ALTER TABLE main.metrics_table 
  DROP COLUMN metric_1;
  </code></pre>
  
  <p>I was looking through Databricks <a href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/delete.html" rel="noreferrer">documentation</a> on DELETE but it covers only <code>DELETE the rows that match a predicate</code>. </p>
  
  <p>I've also found docs on DROP database, DROP function and DROP table but absolutely nothing on how to delete a column from a delta table. What am I missing here? Is there a standard way to drop a column from a delta table?</p>