Pragmatic SQLite Administration

Catalog Inventory

List Schema Objects

SQLite stores schema objects in sqlite_master, which makes lightweight catalog checks possible.

Program

Play the script to choose an object type and inspect the tables or indexes in the catalog.

catalog_object_inventory.sql 
CREATE TABLE customers (id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE orders (id INTEGER PRIMARY KEY, customer_id INTEGER, total INTEGER);
CREATE INDEX idx_orders_customer ON orders(customer_id);
WITH params(object_type) AS (VALUES ()) SELECT type, name, tbl_name FROM sqlite_master WHERE type = (SELECT object_type FROM params) ORDER BY name;

CREATE TABLE customers (id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE orders (id INTEGER PRIMARY KEY, customer_id INTEGER, total INTEGER);
CREATE INDEX idx_orders_customer ON orders(customer_id);
WITH params(object_type) AS (VALUES ()) SELECT type, name, tbl_name FROM sqlite_master WHERE type = (SELECT object_type FROM params) ORDER BY name;
sqlite_master `sqlite_master` is SQLite's catalog table for schema objects.
object type Filtering by `type` separates tables, indexes, views, and triggers.
stable inventory Catalog queries are useful for small migration or smoke-check scripts.