Data Types (version 3)
- REAL (floating)
- BLOB (blob of data, stored exactly as it was input)
A column with type
INTEGER PRIMARY KEY is an alias for the
ROWID, which is always a 64-bit signed integer.
CREATE TABLE IF NOT EXISTS dogs ( id INTEGER PRIMARY KEY, dog_name VARCHAR(10), good_boy INTEGER DEFAULT 1 -- Boolean, default is TRUE );
PRAGMA commands are SQLite specific and are meta commands regarding operation or non-table data.
Get column information of a given table
Last modified: 202105310513