Table & Column Enumeration

-- Describe table columns
PRAGMA table_info(<table>);

pragma_table_info('accounts');

-- Foreign keys
PRAGMA foreign_key_list(<table>);

-- Index list
PRAGMA index_list(<table>);

-- Index info
PRAGMA index_info('<index_name>');