The [index_list](https://www.sqlite.org/pragma.html#pragma_index_list) pragma will also show them on there.
For those reading along, here's what's currently in the [CREATE TABLE](https://www.sqlite.org/lang_createtable.html#unique_constraints) page:
In most cases, UNIQUE and PRIMARY KEY constraints are implemented by creating a unique index in the database. (The exceptions are INTEGER PRIMARY KEY and PRIMARY KEYs on WITHOUT ROWID tables.) Hence, the following schemas are logically equivalent:
1. CREATE TABLE t1(a, b UNIQUE);
2. CREATE TABLE t1(a, b PRIMARY KEY);
3. CREATE TABLE t1(a, b);
CREATE UNIQUE INDEX t1b ON t1(b);