SQLite 3 · Inspecting the database

List a table's columns

Show column names, types and keys with a pragma.

PRAGMA table_info(users);

Official SQLite 3 documentation

More inspecting the database commands

All inspecting the database commands · SQLite 3 cheatsheet

Was this page helpful?