title: Adding multiple columns with default value (Teradata)
body: <p>I tried to search but I have not found anything. I am trying to add two columns to a table withe a default value (Teradata). I am trying with this statement</p>
  
  <pre><code>ALTER TABLE TEST 
  add (DWH_Change_dt date  default CURRENT_DATE, dwh_create_dt date  default current_date);
  </code></pre>
  
  <p>This does not work with default clause. I get this error</p>
  
  <p>Syntax error, expected something like a 'BETWEEN' keyword or an 'IN' keyword or a 'LIKE' keyword or a 'CONTAINS' keyword between the word 'DWH_Change_dt' and the 'date'</p>
  
  <p>If I add one column at a time it works (without parenthesis). Anyone has any idea? What is wrong?</p>
  
  <p>Thanks,
  Umberto</p>