title: H2 sql how to set column to auto_increment
body: <p>i am trying to set my ID to auto_increment, but it is not doing it. i saved 2 more data into db, all are still getting 0 id. as a result i am not able to set ID as primary key. </p>
  
  <p>how is it possible? can i set the field to auto_increment with JPA annotation or so? </p>
  
  <p>i even tried this command which is the first attempt: </p>
  
  <pre><code>  alter table user alter column id int not null auto_increment;
  </code></pre>
  
  <p>no affect. </p>
  
  <p>can someone help me please</p>
  
  <p>thanks in advance! </p>