sqlite3 app.db 'CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT);'

Category: Databases & SQL

sqlite3 app.db 'CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT);'

Create a table

INTEGER PRIMARY KEY makes id an alias for the rowid, so it auto-increments; TEXT stores strings. SQLite is dynamically typed, so the declared types are conventions. Related: .schema to verify.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.