title: Renaming a column in sql using jdbc
body: <p>I created a table (using NetBeans I went to Databases, into jdbc, into app and created a table). I am 80% sure this is a SQL table but I could be wrong.</p>
  
  <p>I named one of my columns as secretQuestion but now I need to change it to securityQuestion.</p>
  
  <p>I looked online and found the following:</p>
  
  <pre><code>ALTER table app.mytable CHANGE secretQuestion to securityQuestion;
  ALTER table app.mytable RENAME secretQuestion to securityQuestion varchar (100);
  </code></pre>
  
  <p>neither CHANGE nor RENAME are recognized.</p>
  
  <p>I am a slow-witted newbie so be very specific in your answer so that I can follow along!</p>
  
  <p>I am using Derby!</p>