title: Making Executable Sqlite Commands Android
body: <p>While learning the basics of Sqlite I continue to stumble across the same problem of understanding how sqlite commands are writen in Android
  The sqlite commands are writen and exectuted like this...</p>
  
  <pre><code>    private static final String DATABASE_CREATE = "create table " 
        + TABLE_TODO
        + "(" 
        + COLUMN_ID + " integer primary key autoincrement, " 
        + COLUMN_CATEGORY + " text not null, " 
        + COLUMN_SUMMARY + " text not null," 
        + COLUMN_DESCRIPTION
        + " text not null" 
        + ");";
  
    public static void onCreate(SQLiteDatabase database) {
      database.execSQL(DATABASE_CREATE);
    }
  </code></pre>
  
  <p>However on the sqlite documentation they show something like this<img src="https://i.stack.imgur.com/eZMRA.gif" alt="enter image description here"></p>
  
  <p>The data in the picture seems to greatly differ from the information given in the code. </p>
  
  <p>Am I just reading the picture wrong, and if so can anyone explain to me how commands like this are setup or point me towards resources that explain how theses commands are setup.</p>
  
  <p>Edit:
  1. In the being it has rails that go off and say "temp" could that be added to "create table" to make "create temp table." </p>
  
  <ol start="2">
  <li>Lastly, what does "Without rowids" do. It is not in this command but if it was what would it do.</li>
  </ol>