title: DB2 400 drop column
body: <p>I want to drop a column called <code>id</code> which is an auto incrementing PK.</p>
  
  <p>The SQL: </p>
  
  <pre><code>alter table "CO88GT"."XGLCTL" drop column id cascade;
  </code></pre>
  
  <p>And I get:</p>
  
  <pre><code>Error: [SQL0952] Processing of the SQL statement ended.  Reason code 10.
  
  SQLState:  57014
  
  ErrorCode: -952
  </code></pre>
  
  <p>I could be wrong but I think it has something to do with preventing the table from losing data.  To get around this issue I need to create a new table without the column and copy the data from the old table into the new table and then replace the old table with the new table.</p>