CREATE TABLE IF NOT EXISTS

CREATE TABLE [IF NOT EXISTS] [schema_name].TABLE_NAME (
    column_1 INTEGER PRIMARY KEY,
    column_2 INTEGER NOT NULL,
    column_3 REAL DEFAULT 0,
    column_4 TEXT,
    column_5 BLOB DEFAULT NULL,
    table_constraints
) [WITHOUT ROWID];

CREATE TABLE IF NOT EXISTS t (a INTEGER PRIMARY KEY, b INTEGER NOT NULL, c REAL DEFAULT 0, d TEXT, e BLOB DEFAULT NULL);

DROP TABLE IF EXISTS t;