Verify that this process has successfully created the table by using the .schema command in the SQLite CLI. code example

Example: sqlite populate database from file command shell

sqlite3 test.db
sqlite3> .read create-tables.sql