title: alter table drop column syntax error using sqlite
body: <p>This is the schema of my table:</p>
  
  <pre><code>create table LPCG(ID integer primary key, PCG text, Desc text, test text);
  </code></pre>
  
  <p>I wish to drop the column "test", and hence use the command:</p>
  
  <pre><code>alter table LPCG drop column test;
  </code></pre>
  
  <p>This is the error message I get:</p>
  
  <pre><code>Error: near "drop": syntax error
  </code></pre>
  
  <p>Can someone please help me correct my error?</p>
  
  <p>An additional question is: I understand that ID is the primary key attribute. Would I be able to drop that column? If not, is there a workaround which anyone has used?</p>
  
  <p>Thanks in advance for any help.</p>