title: Quick SQL question: Correct syntax for creating a table with a primary key in H2?
body: <p>I'm currently starting a new Java application using the <a href="http://www.h2database.com/html/main.html" rel="noreferrer">H2 database</a>, but I have some confusion about basic SQL use for creating tables.  How do I make a table of entries (strings) each with unique, auto-incrementing, non-null, integer primary keys?  One of the most basic things to do, but I'm not sure offhand what the correct way to do it with H2 is.</p>
  
  <p>I blame these for my confusion (specifies more than one way of doing the same thing between different databases; can't figure the right way for H2, though):
  <a href="http://www.w3schools.com/Sql/sql_primarykey.asp" rel="noreferrer">http://www.w3schools.com/Sql/sql_primarykey.asp</a>
  <a href="http://www.w3schools.com/Sql/sql_autoincrement.asp" rel="noreferrer">http://www.w3schools.com/Sql/sql_autoincrement.asp</a></p>