sqlite>PRAGMA hoge
でhogeの部分に指定できるやつの一覧。
- application_id
- auto_vacuum
- automatic_index
- busy_timeout
- cache_size
- cache_spill
- case_sensitive_like
- checkpoint_fullfsync
- collation_list
- compile_options
- database_list
- defer_foreign_keys
- encoding
- foreign_key_check
- foreign_key_list
- foreign_keys
- freelist_count
- fullfsync
- ignore_check_constraints
- incremental_vacuum
- index_info
- index_list
- integrity_check
- journal_mode
- journal_size_limit
- legacy_file_format
- locking_mode
- max_page_count
- mmap_size
- page_count
- page_size
- query_only
- quick_check
- read_uncommitted
- recursive_triggers
- reverse_unordered_selects
- schema_version
- secure_delete
- shrink_memory
- soft_heap_limit
- synchronous
- table_info
- temp_store
- user_version
- wal_autocheckpoint
- wal_checkpoint
- writable_schema