title: SQLite data dictionary tables and columns
body: <p>Can you tell us the names of all tables and table columns in the SQLite data dictionary?</p>
  
  <p>Update:</p>
  
  <p>I was using this information for a Basic4Android app I'm developing.</p>
  
  <p>Here is the actual segment of coding I used:</p>
  
  <pre><code>' Create the PeopleToVisit table which holds lookup data about each visit.
  '-------------------------------------------------------------------------
  If SQL.ExecQuerySingleResult( _
      "SELECT count(name) FROM sqlite_master WHERE type='table' AND name='PeopleToVisit'") _
      = 0 Then
  
      ToastMessageShow("Creating the People to Visit table.", False)
  
      ' Create it now since it doesn't yet exist.
      '------------------------------------------
      SQL.ExecNonQuery("CREATE TABLE PeopleToVisit (" &amp; _
          "Id INTEGER PRIMARY KEY, " &amp; _
          "FirstName TEXT, " &amp; _
          "LastName TEXT, " &amp; _
          "Address1 TEXT, " &amp; _
          "Address2 TEXT, " &amp; _
          "City TEXT, " &amp; _
          "State TEXT, " &amp; _
          "Zip TEXT " &amp; _
          ")")
  End If
  
  ' New table columns for Version 1.2
  '----------------------------------
  
  ' Coding for when new data columns need to be added to the database table.
  '-------------------------------------------------------------------------
  strCreateTableStatement = _
      SQL.ExecQuerySingleResult("SELECT sql " &amp; _
                                  "FROM sqlite_master " &amp; _
                                 "WHERE Type = 'table' AND name = 'PeopleToVisit'")
  
  ' Check if the new columns are in the table.
  '-------------------------------------------
  If strCreateTableStatement.IndexOf("PrimaryPhone TEXT") = -1 Then
  
      ' We need to add the new columns to the table.
      '---------------------------------------------
      SQL.ExecNonQuery("ALTER TABLE PeopleToVisit ADD COLUMN PrimaryPhone TEXT")
      SQL.ExecNonQuery("ALTER TABLE PeopleToVisit ADD COLUMN SecondaryPhone TEXT")
      SQL.ExecNonQuery("ALTER TABLE PeopleToVisit ADD COLUMN Email TEXT")
      SQL.ExecNonQuery("ALTER TABLE PeopleToVisit ADD COLUMN LastVisitNote TEXT")     
  End If
  </code></pre>