Android SQLite create query syntax diagram


All SQLite create queries are based on the following syntax diagram:

sqlite syntax diagram

Here, the keyword create table is used to create a table. This is followed by the table name, the declaration of columns, and their datatype. After preparing our SQL statement, we will execute it using the execSQL() method of the SQLite database.

In case something is wrong with the query statement that we built earlier, we will encounter the exception, android.database.sqlite.SQLiteException. By default, the database is formed in the internal memory space allocated to the application. The folder can be found at


Based on Android SQLite Essentials book:
Android SQLite Essentials