SQLite: CREATE TABLE

Define a stable key and a NOT NULL field; test an invalid row.

How to study this source

• How do I store related data and query it correctly?

  coreColumn definitions and constraints

  Define a stable key and a NOT NULL field; test an invalid row.

Ideas and questions

Read background definitions when a term blocks the argument. Then return to the source and reconstruct its claim in your own words.

Read alongside, read against

• SQLite: SQL Language Expressions

  SQLite developers. Compare assumptions, evidence and scope with the source above. These are editorial companions, not necessarily direct responses.

• SQLite: UPDATE

  SQLite developers. Compare assumptions, evidence and scope with the source above. These are editorial companions, not necessarily direct responses.

• SQLite: DELETE

  SQLite developers. Compare assumptions, evidence and scope with the source above. These are editorial companions, not necessarily direct responses.

• SQLite: SQLite Online Backup API

  SQLite developers. Compare assumptions, evidence and scope with the source above. These are editorial companions, not necessarily direct responses.