SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE glyph (
    id int NOT NULL CHECK (id > 10),
    CHECK (id < 20),
    CHECK (id <> 15)
)
✓
INSERT INTO glyph VALUES (11)
✓
SELECT * FROM glyph


id


11


ALTER TABLE glyph
    ADD COLUMN aspect int NOT NULL DEFAULT 101 CHECK (aspect > 100)


CASE WHEN quick_check GLOB 'CHECK*' THEN raise(ABORT,'CHECK constraint failed') ELSE raise(ABORT,'NOT NULL constraint failed') END


INSERT INTO glyph VALUES (12, 108)
✓
SELECT * FROM glyph


id
aspect


11
101

12
108