/* List values of PRAGMAs (settings). */

SELECT *
FROM (
    SELECT 'analysis_limit' AS name, analysis_limit AS value FROM pragma_analysis_limit
    UNION ALL SELECT 'application_id', *          FROM pragma_application_id
    UNION ALL SELECT 'auto_vacuum', *             FROM pragma_auto_vacuum
    UNION ALL SELECT 'automatic_index', *         FROM pragma_automatic_index
    UNION ALL SELECT 'busy_timeout', *            FROM pragma_busy_timeout
    UNION ALL SELECT 'cache_size', *              FROM pragma_cache_size
    UNION ALL SELECT 'cache_spill', *             FROM pragma_cache_spill
    UNION ALL SELECT 'cell_size_check', *         FROM pragma_cell_size_check
    UNION ALL SELECT 'checkpoint_fullfsync', *    FROM pragma_checkpoint_fullfsync
    UNION ALL SELECT 'data_version', *            FROM pragma_data_version
    UNION ALL SELECT 'defer_foreign_keys', *      FROM pragma_defer_foreign_keys
    UNION ALL SELECT 'freelist_count', *          FROM pragma_freelist_count
    UNION ALL SELECT 'fullfsync', *               FROM pragma_fullfsync
    UNION ALL SELECT 'hard_heap_limit', *         FROM pragma_hard_heap_limit
    UNION ALL SELECT 'ignore_check_constraints', * FROM pragma_ignore_check_constraints
    UNION ALL SELECT 'journal_size_limit', *      FROM pragma_journal_size_limit
    UNION ALL SELECT 'legacy_alter_table', *      FROM pragma_legacy_alter_table
    UNION ALL SELECT 'max_page_count', *          FROM pragma_max_page_count
    UNION ALL SELECT 'page_size', *               FROM pragma_page_size
    UNION ALL SELECT 'query_only', *              FROM pragma_query_only
    UNION ALL SELECT 'read_uncommitted', *        FROM pragma_read_uncommitted
    UNION ALL SELECT 'recursive_triggers', *      FROM pragma_recursive_triggers
    UNION ALL SELECT 'reverse_unordered_selects', * FROM pragma_reverse_unordered_selects
    UNION ALL SELECT 'soft_heap_limit', *         FROM pragma_soft_heap_limit
    UNION ALL SELECT 'synchronous', *             FROM pragma_synchronous
    UNION ALL SELECT 'temp_store', *              FROM pragma_temp_store
    UNION ALL SELECT 'threads', *                 FROM pragma_threads
    UNION ALL SELECT 'trusted_schema', *          FROM pragma_trusted_schema
    UNION ALL SELECT 'user_version', *            FROM pragma_user_version
)
WHERE value != 0