· last year · May 19, 2024, 10:25 AM
1CREATE TABLE [IF NOT EXISTS] [schema_name].table_name (
2 column_1 INTEGER PRIMARY KEY,
3 column_2 INTEGER NOT NULL,
4 column_3 REAL DEFAULT 0,
5 column_4 TEXT,
6 column_5 BLOB DEFAULT NULL,
7 table_constraints
8) [WITHOUT ROWID];