title: Adding a column to multiple tables in MS Access using SQL
body: <p>I have an Access database with almost 200 tables. I would like to rename the fields of many of these (to make it easier when I analyze the data in R). I've discovered that you can't simply rename fields in Access, but have to do it the hard way of adding a new column, transferring data, then dropping the old column.</p>
  
  <p>Is there a way to do this for multiple tables (or multiple tables and columns) at once using SQL?</p>
  
  <p>I tried this:</p>
  
  <pre><code>ALTER TABLE * FROM MSysObjects ADD COLUMN colname NUMBER
  </code></pre>
  
  <p>as well as this:</p>
  
  <pre><code>ALTER TABLE table1, table2, table3... ADD COLUMN colname NUMBER
  </code></pre>
  
  <p>but neither seem to work.</p>
  
  <p>Is this possible at all? Does anyone know how to code this?</p>