title: In H2 Database, add index while table creation in single query
body: <p>I am trying to create table having different indexes with single query but H2 gives Error for example:</p>
  
  <pre><code>create table tbl_Cust
  (
    id int primary key auto_increment not null, 
    fid int,
    c_name varchar(50),
    INDEX (fid)
  );
  </code></pre>
  
  <p>but this gives error as </p>
  
  <pre><code>Unknown data type: "("; SQL statement:
  [Error Code: 50004]
  [SQL State: HY004]
  </code></pre>
  
  <p>Due to this I have to run 2 different queries to create table with Index. First query to create table and then second query to add index with</p>
  
  <pre><code>create INDEX c_fid on tbl_Cust(fid);
  </code></pre>
  
  <p>Is there something wrong in my query or H2 simply does not support this creation of table with index in single query?</p>