title: How to delete column from all tables in SQL Server
body: <p>I want to delete the <code>ABCDEF</code> column from all tables of my database. I am trying this code:</p>
  
  <pre><code>declare @SQL nvarchar(max)  
  
  SELECT 
      @SQL = STUFF((SELECT ' DROP column ' + quotename(TABLE_SCHEMA) + '.' + quotename(table_NAME ) +'.ABCDEF;'
  FROM
      information_schema.columns 
  FOR XML PATH('')),1,2,'')
  
  PRINT @SQL
  
  EXECUTE (@SQL)
  </code></pre>
  
  <p>But I am getting an error </p>
  
  <blockquote>
    <p>incorrect syntax near column</p>
  </blockquote>
  
  <p>How to do this?</p>