title: Is it posible to have AUTOINCREMENT without setting it as PRIMARY KEY In ANDROID SQLite
body: <p>I have tried with INTEGER AUTOINCREMENT while creating Table in Android Sqlite. But it shows error.
  But it works fine while giving INTEGER PRIMARY KEY AUTOINCREMENT.</p>
  
  <p>My requirement is that, the column with AUTOINCREMENT shouldn't be a primary key.</p>
  
  <pre><code>db.execSQL("CREATE TABLE " + Table_KOT_ITEMS_TEMP + "(" + col_Item_Name
                  + " varchar(40) NOT NULL," + col_Ref_No
                  + " int(11) NOT NULL DEFAULT '0'," + col_Table_No
                  + " varchar(6) NOT NULL DEFAULT '0'," + col_Kot_No
                  + " int(11) NOT NULL DEFAULT '0'," + col_Main_Item_Code
                  + " varchar(10) NOT NULL," + col_Item_Type
                  + " varchar(10) NOT NULL," + col_Item_Amount
                  + " decimal(10,2) DEFAULT '0.00'," + col_Item_Qty
                  + " decimal(9,3) NOT NULL DEFAULT '0.000'," + col_No_Of_Persons
                  + " varchar(6) NOT NULL," + col_Dum_Unique
                  + " varchar(25) NOT NULL," + col_CheckBox
                  + " char(5) NOT NULL," + col_Item_Auto_ID
                  + " INTEGER PRIMARY KEY AUTOINCREMENT)");
  </code></pre>