🗄️

SQLite Explorer

Structure tab

Columns and indexes for any table.

Columns & indexes

Open a table's structure from the sidebar's hover icon (🏗️) to see two grids:

  • Columns — name, declared type, NOT NULL flag, default value and primary-key flag (straight from PRAGMA table_info).
  • Indexes — index name, uniqueness, origin (auto-created for PK/UNIQUE vs. explicit) and the indexed columns (from PRAGMA index_list + PRAGMA index_info).
Structure tab — columns grid and indexes grid
Structure tab — columns grid and indexes grid