title: SQL - drop a column in netezza
body: <p>I have a  table<code>table1</code> like below from which i'm trying to drop a column.</p>
  <h3>table1</h3>
  <pre><code>id name time    value
  ---------------------
  1 john  11:00   324
  2 NULL  12:00   645
  3 NULL  13:00   324
  4 jane  11:00   132
  5 NULL  12:00   30
  </code></pre>
  <p>A temp table is created as the original table cannot be altered due to permissions. This case may be very simple to be done by selecting everything except id , but what I really need to do is get rid of one column when there are large number of cols.</p>
  <pre><code>create temp table table2 as(
  select * from table1
  ) distribute on random;
  
  alter table table2 drop column id;
  </code></pre>
  <p>this gives the error - <code>Drop behaviour (RESTRICT | CASCADE) needs to be specified when dropping a column or constraint</code></p>
  <p>How should the alter table statement be ?</p>