Database Schema Information

Page 25 of 41
[prev] [next]

Original text of statements used to create table, indices, views, and triggers is stored in the SQLITE_MASTER table.
```
CREATE TABLE sqlite_master (
  type text,
  name text,
  tbl_name text,
  rootpage integer,
  sql text
);
```

Temporary objects stored in SQLITE_TEMP_MASTER.

These tables are read-only.

Parsed information available using PRAGMAs.
- PRAGMA table_info(table)
- PRAGMA index_info(index)
- PRAGMA index_list(table)