blob: 60ab75a73c2ba0961abed30c0428221fbd364952 [file] [log] [blame]
drh67e65e52015-02-02 21:34:54 +00001/* DO NOT EDIT!
2** This file is automatically generated by the script at
3** ../tool/mkpragmatab.tcl. To update the set of pragmas, edit
4** that script and rerun it.
5*/
drhc232aca2016-12-15 16:01:17 +00006
7/* The various pragma types */
drhb48c0d52020-02-07 01:12:53 +00008#define PragTyp_ACTIVATE_EXTENSIONS 0
drh49a76a82020-03-31 20:57:06 +00009#define PragTyp_ANALYSIS_LIMIT 1
10#define PragTyp_HEADER_VALUE 2
11#define PragTyp_AUTO_VACUUM 3
12#define PragTyp_FLAG 4
13#define PragTyp_BUSY_TIMEOUT 5
14#define PragTyp_CACHE_SIZE 6
15#define PragTyp_CACHE_SPILL 7
16#define PragTyp_CASE_SENSITIVE_LIKE 8
17#define PragTyp_COLLATION_LIST 9
18#define PragTyp_COMPILE_OPTIONS 10
19#define PragTyp_DATA_STORE_DIRECTORY 11
20#define PragTyp_DATABASE_LIST 12
21#define PragTyp_DEFAULT_CACHE_SIZE 13
22#define PragTyp_ENCODING 14
23#define PragTyp_FOREIGN_KEY_CHECK 15
24#define PragTyp_FOREIGN_KEY_LIST 16
25#define PragTyp_FUNCTION_LIST 17
26#define PragTyp_HARD_HEAP_LIMIT 18
27#define PragTyp_INCREMENTAL_VACUUM 19
28#define PragTyp_INDEX_INFO 20
29#define PragTyp_INDEX_LIST 21
30#define PragTyp_INTEGRITY_CHECK 22
31#define PragTyp_JOURNAL_MODE 23
32#define PragTyp_JOURNAL_SIZE_LIMIT 24
33#define PragTyp_LOCK_PROXY_FILE 25
34#define PragTyp_LOCKING_MODE 26
35#define PragTyp_PAGE_COUNT 27
36#define PragTyp_MMAP_SIZE 28
37#define PragTyp_MODULE_LIST 29
38#define PragTyp_OPTIMIZE 30
39#define PragTyp_PAGE_SIZE 31
40#define PragTyp_PRAGMA_LIST 32
41#define PragTyp_SECURE_DELETE 33
42#define PragTyp_SHRINK_MEMORY 34
43#define PragTyp_SOFT_HEAP_LIMIT 35
44#define PragTyp_SYNCHRONOUS 36
45#define PragTyp_TABLE_INFO 37
drh2e50f672021-09-21 17:26:23 +000046#define PragTyp_TABLE_LIST 38
47#define PragTyp_TEMP_STORE 39
48#define PragTyp_TEMP_STORE_DIRECTORY 40
49#define PragTyp_THREADS 41
50#define PragTyp_WAL_AUTOCHECKPOINT 42
51#define PragTyp_WAL_CHECKPOINT 43
52#define PragTyp_LOCK_STATUS 44
53#define PragTyp_STATS 45
drhc232aca2016-12-15 16:01:17 +000054
55/* Property flags associated with various pragma. */
56#define PragFlg_NeedSchema 0x01 /* Force schema load before running */
57#define PragFlg_NoColumns 0x02 /* OP_ResultRow called with zero columns */
dan9e1ab1a2017-01-05 19:32:48 +000058#define PragFlg_NoColumns1 0x04 /* zero columns if RHS argument is present */
59#define PragFlg_ReadOnly 0x08 /* Read-only HEADER_VALUE */
60#define PragFlg_Result0 0x10 /* Acts as query when no argument */
61#define PragFlg_Result1 0x20 /* Acts as query when has one argument */
62#define PragFlg_SchemaOpt 0x40 /* Schema restricts name search if present */
63#define PragFlg_SchemaReq 0x80 /* Schema required - "main" is default */
drhc232aca2016-12-15 16:01:17 +000064
65/* Names of columns for pragmas that return multi-column result
66** or that return single-column results where the name of the
67** result column is different from the name of the pragma
68*/
69static const char *const pragCName[] = {
drhbdc97442018-10-01 21:26:30 +000070 /* 0 */ "id", /* Used by: foreign_key_list */
71 /* 1 */ "seq",
72 /* 2 */ "table",
73 /* 3 */ "from",
74 /* 4 */ "to",
75 /* 5 */ "on_update",
76 /* 6 */ "on_delete",
77 /* 7 */ "match",
78 /* 8 */ "cid", /* Used by: table_xinfo */
79 /* 9 */ "name",
80 /* 10 */ "type",
81 /* 11 */ "notnull",
82 /* 12 */ "dflt_value",
83 /* 13 */ "pk",
84 /* 14 */ "hidden",
85 /* table_info reuses 8 */
drh2e50f672021-09-21 17:26:23 +000086 /* 15 */ "schema", /* Used by: table_list */
87 /* 16 */ "name",
88 /* 17 */ "type",
89 /* 18 */ "ncol",
90 /* 19 */ "wr",
91 /* 20 */ "strict",
92 /* 21 */ "seqno", /* Used by: index_xinfo */
93 /* 22 */ "cid",
94 /* 23 */ "name",
95 /* 24 */ "desc",
96 /* 25 */ "coll",
97 /* 26 */ "key",
98 /* 27 */ "name", /* Used by: function_list */
99 /* 28 */ "builtin",
100 /* 29 */ "type",
101 /* 30 */ "enc",
102 /* 31 */ "narg",
103 /* 32 */ "flags",
104 /* 33 */ "tbl", /* Used by: stats */
105 /* 34 */ "idx",
106 /* 35 */ "wdth",
107 /* 36 */ "hght",
108 /* 37 */ "flgs",
109 /* 38 */ "seq", /* Used by: index_list */
110 /* 39 */ "name",
111 /* 40 */ "unique",
112 /* 41 */ "origin",
113 /* 42 */ "partial",
114 /* 43 */ "table", /* Used by: foreign_key_check */
115 /* 44 */ "rowid",
116 /* 45 */ "parent",
117 /* 46 */ "fkid",
118 /* index_info reuses 21 */
119 /* 47 */ "seq", /* Used by: database_list */
120 /* 48 */ "name",
121 /* 49 */ "file",
122 /* 50 */ "busy", /* Used by: wal_checkpoint */
123 /* 51 */ "log",
124 /* 52 */ "checkpointed",
125 /* collation_list reuses 38 */
126 /* 53 */ "database", /* Used by: lock_status */
127 /* 54 */ "status",
128 /* 55 */ "cache_size", /* Used by: default_cache_size */
drhbdc97442018-10-01 21:26:30 +0000129 /* module_list pragma_list reuses 9 */
drh2e50f672021-09-21 17:26:23 +0000130 /* 56 */ "timeout", /* Used by: busy_timeout */
drhc232aca2016-12-15 16:01:17 +0000131};
132
133/* Definitions of all built-in pragmas */
drh2fcc1592016-12-15 20:59:03 +0000134typedef struct PragmaName {
drhc232aca2016-12-15 16:01:17 +0000135 const char *const zName; /* Name of pragma */
136 u8 ePragTyp; /* PragTyp_XXX value */
137 u8 mPragFlg; /* Zero or more PragFlg_XXX values */
138 u8 iPragCName; /* Start of column names in pragCName[] */
139 u8 nPragCName; /* Num of col names. 0 means use pragma name */
drhfd748c62018-10-30 16:25:35 +0000140 u64 iArg; /* Extra argument */
drh2fcc1592016-12-15 20:59:03 +0000141} PragmaName;
142static const PragmaName aPragmaName[] = {
drhb48c0d52020-02-07 01:12:53 +0000143#if defined(SQLITE_ENABLE_CEROD)
drhc232aca2016-12-15 16:01:17 +0000144 {/* zName: */ "activate_extensions",
145 /* ePragTyp: */ PragTyp_ACTIVATE_EXTENSIONS,
146 /* ePragFlg: */ 0,
147 /* ColNames: */ 0, 0,
148 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000149#endif
drh49a76a82020-03-31 20:57:06 +0000150 {/* zName: */ "analysis_limit",
151 /* ePragTyp: */ PragTyp_ANALYSIS_LIMIT,
152 /* ePragFlg: */ PragFlg_Result0,
153 /* ColNames: */ 0, 0,
154 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000155#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000156 {/* zName: */ "application_id",
157 /* ePragTyp: */ PragTyp_HEADER_VALUE,
dan9e1ab1a2017-01-05 19:32:48 +0000158 /* ePragFlg: */ PragFlg_NoColumns1|PragFlg_Result0,
drhc232aca2016-12-15 16:01:17 +0000159 /* ColNames: */ 0, 0,
160 /* iArg: */ BTREE_APPLICATION_ID },
drh67e65e52015-02-02 21:34:54 +0000161#endif
162#if !defined(SQLITE_OMIT_AUTOVACUUM)
drhc232aca2016-12-15 16:01:17 +0000163 {/* zName: */ "auto_vacuum",
164 /* ePragTyp: */ PragTyp_AUTO_VACUUM,
dan9e1ab1a2017-01-05 19:32:48 +0000165 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000166 /* ColNames: */ 0, 0,
167 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000168#endif
169#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
170#if !defined(SQLITE_OMIT_AUTOMATIC_INDEX)
drhc232aca2016-12-15 16:01:17 +0000171 {/* zName: */ "automatic_index",
172 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000173 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000174 /* ColNames: */ 0, 0,
175 /* iArg: */ SQLITE_AutoIndex },
drh67e65e52015-02-02 21:34:54 +0000176#endif
177#endif
drhc232aca2016-12-15 16:01:17 +0000178 {/* zName: */ "busy_timeout",
179 /* ePragTyp: */ PragTyp_BUSY_TIMEOUT,
180 /* ePragFlg: */ PragFlg_Result0,
drh2e50f672021-09-21 17:26:23 +0000181 /* ColNames: */ 56, 1,
drhc232aca2016-12-15 16:01:17 +0000182 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000183#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000184 {/* zName: */ "cache_size",
185 /* ePragTyp: */ PragTyp_CACHE_SIZE,
dan9e1ab1a2017-01-05 19:32:48 +0000186 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000187 /* ColNames: */ 0, 0,
188 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000189#endif
190#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000191 {/* zName: */ "cache_spill",
192 /* ePragTyp: */ PragTyp_CACHE_SPILL,
dan9e1ab1a2017-01-05 19:32:48 +0000193 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000194 /* ColNames: */ 0, 0,
195 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000196#endif
drh08652b52019-05-08 17:27:18 +0000197#if !defined(SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA)
drhc232aca2016-12-15 16:01:17 +0000198 {/* zName: */ "case_sensitive_like",
199 /* ePragTyp: */ PragTyp_CASE_SENSITIVE_LIKE,
dane1ff3f52017-01-06 13:49:40 +0000200 /* ePragFlg: */ PragFlg_NoColumns,
drhc232aca2016-12-15 16:01:17 +0000201 /* ColNames: */ 0, 0,
202 /* iArg: */ 0 },
drh08652b52019-05-08 17:27:18 +0000203#endif
drhc232aca2016-12-15 16:01:17 +0000204 {/* zName: */ "cell_size_check",
205 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000206 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000207 /* ColNames: */ 0, 0,
208 /* iArg: */ SQLITE_CellSizeCk },
drh67e65e52015-02-02 21:34:54 +0000209#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000210 {/* zName: */ "checkpoint_fullfsync",
211 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000212 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000213 /* ColNames: */ 0, 0,
214 /* iArg: */ SQLITE_CkptFullFSync },
drh67e65e52015-02-02 21:34:54 +0000215#endif
216#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000217 {/* zName: */ "collation_list",
218 /* ePragTyp: */ PragTyp_COLLATION_LIST,
219 /* ePragFlg: */ PragFlg_Result0,
drh2e50f672021-09-21 17:26:23 +0000220 /* ColNames: */ 38, 2,
drhc232aca2016-12-15 16:01:17 +0000221 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000222#endif
223#if !defined(SQLITE_OMIT_COMPILEOPTION_DIAGS)
drhc232aca2016-12-15 16:01:17 +0000224 {/* zName: */ "compile_options",
225 /* ePragTyp: */ PragTyp_COMPILE_OPTIONS,
226 /* ePragFlg: */ PragFlg_Result0,
227 /* ColNames: */ 0, 0,
228 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000229#endif
230#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000231 {/* zName: */ "count_changes",
232 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000233 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000234 /* ColNames: */ 0, 0,
235 /* iArg: */ SQLITE_CountRows },
drh67e65e52015-02-02 21:34:54 +0000236#endif
237#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && SQLITE_OS_WIN
drhc232aca2016-12-15 16:01:17 +0000238 {/* zName: */ "data_store_directory",
239 /* ePragTyp: */ PragTyp_DATA_STORE_DIRECTORY,
dan9e1ab1a2017-01-05 19:32:48 +0000240 /* ePragFlg: */ PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000241 /* ColNames: */ 0, 0,
242 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000243#endif
244#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000245 {/* zName: */ "data_version",
246 /* ePragTyp: */ PragTyp_HEADER_VALUE,
dan9e1ab1a2017-01-05 19:32:48 +0000247 /* ePragFlg: */ PragFlg_ReadOnly|PragFlg_Result0,
drhc232aca2016-12-15 16:01:17 +0000248 /* ColNames: */ 0, 0,
249 /* iArg: */ BTREE_DATA_VERSION },
drh67e65e52015-02-02 21:34:54 +0000250#endif
251#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000252 {/* zName: */ "database_list",
253 /* ePragTyp: */ PragTyp_DATABASE_LIST,
drhf2a777f2022-02-22 20:29:31 +0000254 /* ePragFlg: */ PragFlg_Result0,
drh2e50f672021-09-21 17:26:23 +0000255 /* ColNames: */ 47, 3,
drhc232aca2016-12-15 16:01:17 +0000256 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000257#endif
258#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && !defined(SQLITE_OMIT_DEPRECATED)
drhc232aca2016-12-15 16:01:17 +0000259 {/* zName: */ "default_cache_size",
260 /* ePragTyp: */ PragTyp_DEFAULT_CACHE_SIZE,
dan9e1ab1a2017-01-05 19:32:48 +0000261 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
drh2e50f672021-09-21 17:26:23 +0000262 /* ColNames: */ 55, 1,
drhc232aca2016-12-15 16:01:17 +0000263 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000264#endif
265#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
266#if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
drhc232aca2016-12-15 16:01:17 +0000267 {/* zName: */ "defer_foreign_keys",
268 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000269 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000270 /* ColNames: */ 0, 0,
271 /* iArg: */ SQLITE_DeferFKs },
drh67e65e52015-02-02 21:34:54 +0000272#endif
273#endif
274#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000275 {/* zName: */ "empty_result_callbacks",
276 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000277 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000278 /* ColNames: */ 0, 0,
279 /* iArg: */ SQLITE_NullCallback },
drh67e65e52015-02-02 21:34:54 +0000280#endif
281#if !defined(SQLITE_OMIT_UTF16)
drhc232aca2016-12-15 16:01:17 +0000282 {/* zName: */ "encoding",
283 /* ePragTyp: */ PragTyp_ENCODING,
dan9e1ab1a2017-01-05 19:32:48 +0000284 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000285 /* ColNames: */ 0, 0,
286 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000287#endif
288#if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
drhc232aca2016-12-15 16:01:17 +0000289 {/* zName: */ "foreign_key_check",
290 /* ePragTyp: */ PragTyp_FOREIGN_KEY_CHECK,
drh4b849b02020-07-03 12:32:04 +0000291 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_Result1|PragFlg_SchemaOpt,
drh2e50f672021-09-21 17:26:23 +0000292 /* ColNames: */ 43, 4,
drhc232aca2016-12-15 16:01:17 +0000293 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000294#endif
295#if !defined(SQLITE_OMIT_FOREIGN_KEY)
drhc232aca2016-12-15 16:01:17 +0000296 {/* zName: */ "foreign_key_list",
297 /* ePragTyp: */ PragTyp_FOREIGN_KEY_LIST,
298 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
drhbdc97442018-10-01 21:26:30 +0000299 /* ColNames: */ 0, 8,
drhc232aca2016-12-15 16:01:17 +0000300 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000301#endif
302#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
303#if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
drhc232aca2016-12-15 16:01:17 +0000304 {/* zName: */ "foreign_keys",
305 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000306 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000307 /* ColNames: */ 0, 0,
308 /* iArg: */ SQLITE_ForeignKeys },
drh67e65e52015-02-02 21:34:54 +0000309#endif
310#endif
311#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000312 {/* zName: */ "freelist_count",
313 /* ePragTyp: */ PragTyp_HEADER_VALUE,
dan9e1ab1a2017-01-05 19:32:48 +0000314 /* ePragFlg: */ PragFlg_ReadOnly|PragFlg_Result0,
drhc232aca2016-12-15 16:01:17 +0000315 /* ColNames: */ 0, 0,
316 /* iArg: */ BTREE_FREE_PAGE_COUNT },
drh67e65e52015-02-02 21:34:54 +0000317#endif
318#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000319 {/* zName: */ "full_column_names",
320 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000321 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000322 /* ColNames: */ 0, 0,
323 /* iArg: */ SQLITE_FullColNames },
324 {/* zName: */ "fullfsync",
325 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000326 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000327 /* ColNames: */ 0, 0,
328 /* iArg: */ SQLITE_FullFSync },
drh67e65e52015-02-02 21:34:54 +0000329#endif
drhab53bb62017-07-07 15:43:22 +0000330#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
drhcc3f3d12019-08-17 15:27:58 +0000331#if !defined(SQLITE_OMIT_INTROSPECTION_PRAGMAS)
drhab53bb62017-07-07 15:43:22 +0000332 {/* zName: */ "function_list",
333 /* ePragTyp: */ PragTyp_FUNCTION_LIST,
334 /* ePragFlg: */ PragFlg_Result0,
drh2e50f672021-09-21 17:26:23 +0000335 /* ColNames: */ 27, 6,
drhab53bb62017-07-07 15:43:22 +0000336 /* iArg: */ 0 },
337#endif
drh8ae11aa2017-07-07 17:33:07 +0000338#endif
drh10c0e712019-04-25 18:15:38 +0000339 {/* zName: */ "hard_heap_limit",
340 /* ePragTyp: */ PragTyp_HARD_HEAP_LIMIT,
341 /* ePragFlg: */ PragFlg_Result0,
342 /* ColNames: */ 0, 0,
343 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000344#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
345#if !defined(SQLITE_OMIT_CHECK)
drhc232aca2016-12-15 16:01:17 +0000346 {/* zName: */ "ignore_check_constraints",
347 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000348 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000349 /* ColNames: */ 0, 0,
350 /* iArg: */ SQLITE_IgnoreChecks },
drh67e65e52015-02-02 21:34:54 +0000351#endif
352#endif
353#if !defined(SQLITE_OMIT_AUTOVACUUM)
drhc232aca2016-12-15 16:01:17 +0000354 {/* zName: */ "incremental_vacuum",
355 /* ePragTyp: */ PragTyp_INCREMENTAL_VACUUM,
356 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_NoColumns,
357 /* ColNames: */ 0, 0,
358 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000359#endif
360#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000361 {/* zName: */ "index_info",
362 /* ePragTyp: */ PragTyp_INDEX_INFO,
363 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
drh2e50f672021-09-21 17:26:23 +0000364 /* ColNames: */ 21, 3,
drhc232aca2016-12-15 16:01:17 +0000365 /* iArg: */ 0 },
366 {/* zName: */ "index_list",
367 /* ePragTyp: */ PragTyp_INDEX_LIST,
368 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
drh2e50f672021-09-21 17:26:23 +0000369 /* ColNames: */ 38, 5,
drhc232aca2016-12-15 16:01:17 +0000370 /* iArg: */ 0 },
371 {/* zName: */ "index_xinfo",
372 /* ePragTyp: */ PragTyp_INDEX_INFO,
373 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
drh2e50f672021-09-21 17:26:23 +0000374 /* ColNames: */ 21, 6,
drhc232aca2016-12-15 16:01:17 +0000375 /* iArg: */ 1 },
drh67e65e52015-02-02 21:34:54 +0000376#endif
377#if !defined(SQLITE_OMIT_INTEGRITY_CHECK)
drhc232aca2016-12-15 16:01:17 +0000378 {/* zName: */ "integrity_check",
379 /* ePragTyp: */ PragTyp_INTEGRITY_CHECK,
drhb4d9b2b2021-07-20 07:35:07 +0000380 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_Result1|PragFlg_SchemaOpt,
drhc232aca2016-12-15 16:01:17 +0000381 /* ColNames: */ 0, 0,
382 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000383#endif
384#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000385 {/* zName: */ "journal_mode",
386 /* ePragTyp: */ PragTyp_JOURNAL_MODE,
387 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
388 /* ColNames: */ 0, 0,
389 /* iArg: */ 0 },
390 {/* zName: */ "journal_size_limit",
391 /* ePragTyp: */ PragTyp_JOURNAL_SIZE_LIMIT,
392 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq,
393 /* ColNames: */ 0, 0,
394 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000395#endif
drh67e65e52015-02-02 21:34:54 +0000396#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
dan674b8942018-09-20 08:28:01 +0000397 {/* zName: */ "legacy_alter_table",
398 /* ePragTyp: */ PragTyp_FLAG,
399 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
400 /* ColNames: */ 0, 0,
401 /* iArg: */ SQLITE_LegacyAlter },
drh67e65e52015-02-02 21:34:54 +0000402#endif
403#if !defined(SQLITE_OMIT_PAGER_PRAGMAS) && SQLITE_ENABLE_LOCKING_STYLE
drhc232aca2016-12-15 16:01:17 +0000404 {/* zName: */ "lock_proxy_file",
405 /* ePragTyp: */ PragTyp_LOCK_PROXY_FILE,
dan9e1ab1a2017-01-05 19:32:48 +0000406 /* ePragFlg: */ PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000407 /* ColNames: */ 0, 0,
408 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000409#endif
410#if defined(SQLITE_DEBUG) || defined(SQLITE_TEST)
drhc232aca2016-12-15 16:01:17 +0000411 {/* zName: */ "lock_status",
412 /* ePragTyp: */ PragTyp_LOCK_STATUS,
413 /* ePragFlg: */ PragFlg_Result0,
drh2e50f672021-09-21 17:26:23 +0000414 /* ColNames: */ 53, 2,
drhc232aca2016-12-15 16:01:17 +0000415 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000416#endif
417#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000418 {/* zName: */ "locking_mode",
419 /* ePragTyp: */ PragTyp_LOCKING_MODE,
420 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq,
421 /* ColNames: */ 0, 0,
422 /* iArg: */ 0 },
423 {/* zName: */ "max_page_count",
424 /* ePragTyp: */ PragTyp_PAGE_COUNT,
425 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
426 /* ColNames: */ 0, 0,
427 /* iArg: */ 0 },
428 {/* zName: */ "mmap_size",
429 /* ePragTyp: */ PragTyp_MMAP_SIZE,
430 /* ePragFlg: */ 0,
431 /* ColNames: */ 0, 0,
432 /* iArg: */ 0 },
drh2ead47c2017-02-22 20:24:10 +0000433#endif
drhab53bb62017-07-07 15:43:22 +0000434#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
435#if !defined(SQLITE_OMIT_VIRTUALTABLE)
drhcc3f3d12019-08-17 15:27:58 +0000436#if !defined(SQLITE_OMIT_INTROSPECTION_PRAGMAS)
drhab53bb62017-07-07 15:43:22 +0000437 {/* zName: */ "module_list",
438 /* ePragTyp: */ PragTyp_MODULE_LIST,
439 /* ePragFlg: */ PragFlg_Result0,
drhbdc97442018-10-01 21:26:30 +0000440 /* ColNames: */ 9, 1,
drhab53bb62017-07-07 15:43:22 +0000441 /* iArg: */ 0 },
442#endif
443#endif
drh8ae11aa2017-07-07 17:33:07 +0000444#endif
drh03d405f2017-09-12 20:09:31 +0000445#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drh56391f22017-11-01 18:48:54 +0000446#if defined(SQLITE_ENABLE_NOOP_UPDATE)
drh03d405f2017-09-12 20:09:31 +0000447 {/* zName: */ "noop_update",
448 /* ePragTyp: */ PragTyp_FLAG,
449 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
450 /* ColNames: */ 0, 0,
451 /* iArg: */ SQLITE_NoopUpdate },
452#endif
453#endif
drh2ead47c2017-02-22 20:24:10 +0000454 {/* zName: */ "optimize",
455 /* ePragTyp: */ PragTyp_OPTIMIZE,
drh761f6912017-04-03 13:33:51 +0000456 /* ePragFlg: */ PragFlg_Result1|PragFlg_NeedSchema,
drh2ead47c2017-02-22 20:24:10 +0000457 /* ColNames: */ 0, 0,
458 /* iArg: */ 0 },
459#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000460 {/* zName: */ "page_count",
461 /* ePragTyp: */ PragTyp_PAGE_COUNT,
462 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
463 /* ColNames: */ 0, 0,
464 /* iArg: */ 0 },
465 {/* zName: */ "page_size",
466 /* ePragTyp: */ PragTyp_PAGE_SIZE,
dan9e1ab1a2017-01-05 19:32:48 +0000467 /* ePragFlg: */ PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000468 /* ColNames: */ 0, 0,
469 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000470#endif
drh9b747062019-01-31 01:39:01 +0000471#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
472#if defined(SQLITE_DEBUG)
drhc232aca2016-12-15 16:01:17 +0000473 {/* zName: */ "parser_trace",
drh9b747062019-01-31 01:39:01 +0000474 /* ePragTyp: */ PragTyp_FLAG,
475 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000476 /* ColNames: */ 0, 0,
drh9b747062019-01-31 01:39:01 +0000477 /* iArg: */ SQLITE_ParserTrace },
478#endif
drh67e65e52015-02-02 21:34:54 +0000479#endif
drhcc3f3d12019-08-17 15:27:58 +0000480#if !defined(SQLITE_OMIT_INTROSPECTION_PRAGMAS)
drh8ae11aa2017-07-07 17:33:07 +0000481 {/* zName: */ "pragma_list",
482 /* ePragTyp: */ PragTyp_PRAGMA_LIST,
483 /* ePragFlg: */ PragFlg_Result0,
drhbdc97442018-10-01 21:26:30 +0000484 /* ColNames: */ 9, 1,
drh8ae11aa2017-07-07 17:33:07 +0000485 /* iArg: */ 0 },
486#endif
drh67e65e52015-02-02 21:34:54 +0000487#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000488 {/* zName: */ "query_only",
489 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000490 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000491 /* ColNames: */ 0, 0,
492 /* iArg: */ SQLITE_QueryOnly },
drh67e65e52015-02-02 21:34:54 +0000493#endif
494#if !defined(SQLITE_OMIT_INTEGRITY_CHECK)
drhc232aca2016-12-15 16:01:17 +0000495 {/* zName: */ "quick_check",
496 /* ePragTyp: */ PragTyp_INTEGRITY_CHECK,
drhb4d9b2b2021-07-20 07:35:07 +0000497 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_Result1|PragFlg_SchemaOpt,
drhc232aca2016-12-15 16:01:17 +0000498 /* ColNames: */ 0, 0,
499 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000500#endif
501#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000502 {/* zName: */ "read_uncommitted",
503 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000504 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000505 /* ColNames: */ 0, 0,
drh169dd922017-06-26 13:57:49 +0000506 /* iArg: */ SQLITE_ReadUncommit },
drhc232aca2016-12-15 16:01:17 +0000507 {/* zName: */ "recursive_triggers",
508 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000509 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000510 /* ColNames: */ 0, 0,
511 /* iArg: */ SQLITE_RecTriggers },
drhc232aca2016-12-15 16:01:17 +0000512 {/* zName: */ "reverse_unordered_selects",
513 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000514 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000515 /* ColNames: */ 0, 0,
516 /* iArg: */ SQLITE_ReverseOrder },
drh67e65e52015-02-02 21:34:54 +0000517#endif
518#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000519 {/* zName: */ "schema_version",
520 /* ePragTyp: */ PragTyp_HEADER_VALUE,
dan9e1ab1a2017-01-05 19:32:48 +0000521 /* ePragFlg: */ PragFlg_NoColumns1|PragFlg_Result0,
drhc232aca2016-12-15 16:01:17 +0000522 /* ColNames: */ 0, 0,
523 /* iArg: */ BTREE_SCHEMA_VERSION },
drh67e65e52015-02-02 21:34:54 +0000524#endif
525#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000526 {/* zName: */ "secure_delete",
527 /* ePragTyp: */ PragTyp_SECURE_DELETE,
528 /* ePragFlg: */ PragFlg_Result0,
529 /* ColNames: */ 0, 0,
530 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000531#endif
532#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000533 {/* zName: */ "short_column_names",
534 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000535 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000536 /* ColNames: */ 0, 0,
537 /* iArg: */ SQLITE_ShortColNames },
drh67e65e52015-02-02 21:34:54 +0000538#endif
drhc232aca2016-12-15 16:01:17 +0000539 {/* zName: */ "shrink_memory",
540 /* ePragTyp: */ PragTyp_SHRINK_MEMORY,
dane1ff3f52017-01-06 13:49:40 +0000541 /* ePragFlg: */ PragFlg_NoColumns,
drhc232aca2016-12-15 16:01:17 +0000542 /* ColNames: */ 0, 0,
543 /* iArg: */ 0 },
544 {/* zName: */ "soft_heap_limit",
545 /* ePragTyp: */ PragTyp_SOFT_HEAP_LIMIT,
546 /* ePragFlg: */ PragFlg_Result0,
547 /* ColNames: */ 0, 0,
548 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000549#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
550#if defined(SQLITE_DEBUG)
drhc232aca2016-12-15 16:01:17 +0000551 {/* zName: */ "sql_trace",
552 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000553 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000554 /* ColNames: */ 0, 0,
555 /* iArg: */ SQLITE_SqlTrace },
drh67e65e52015-02-02 21:34:54 +0000556#endif
557#endif
drh33bec3f2017-02-17 13:38:15 +0000558#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS) && defined(SQLITE_DEBUG)
drhc232aca2016-12-15 16:01:17 +0000559 {/* zName: */ "stats",
560 /* ePragTyp: */ PragTyp_STATS,
561 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq,
drh2e50f672021-09-21 17:26:23 +0000562 /* ColNames: */ 33, 5,
drhc232aca2016-12-15 16:01:17 +0000563 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000564#endif
565#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000566 {/* zName: */ "synchronous",
567 /* ePragTyp: */ PragTyp_SYNCHRONOUS,
dan9e1ab1a2017-01-05 19:32:48 +0000568 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result0|PragFlg_SchemaReq|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000569 /* ColNames: */ 0, 0,
570 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000571#endif
572#if !defined(SQLITE_OMIT_SCHEMA_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000573 {/* zName: */ "table_info",
574 /* ePragTyp: */ PragTyp_TABLE_INFO,
575 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
drhbdc97442018-10-01 21:26:30 +0000576 /* ColNames: */ 8, 6,
drhc232aca2016-12-15 16:01:17 +0000577 /* iArg: */ 0 },
drh2e50f672021-09-21 17:26:23 +0000578 {/* zName: */ "table_list",
579 /* ePragTyp: */ PragTyp_TABLE_LIST,
580 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1,
581 /* ColNames: */ 15, 6,
drh253888c2021-10-04 13:30:22 +0000582 /* iArg: */ 0 },
drhbdc97442018-10-01 21:26:30 +0000583 {/* zName: */ "table_xinfo",
drh15fc9882018-09-29 19:38:42 +0000584 /* ePragTyp: */ PragTyp_TABLE_INFO,
585 /* ePragFlg: */ PragFlg_NeedSchema|PragFlg_Result1|PragFlg_SchemaOpt,
drhbdc97442018-10-01 21:26:30 +0000586 /* ColNames: */ 8, 7,
drh15fc9882018-09-29 19:38:42 +0000587 /* iArg: */ 1 },
drh67e65e52015-02-02 21:34:54 +0000588#endif
589#if !defined(SQLITE_OMIT_PAGER_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000590 {/* zName: */ "temp_store",
591 /* ePragTyp: */ PragTyp_TEMP_STORE,
dan9e1ab1a2017-01-05 19:32:48 +0000592 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000593 /* ColNames: */ 0, 0,
594 /* iArg: */ 0 },
595 {/* zName: */ "temp_store_directory",
596 /* ePragTyp: */ PragTyp_TEMP_STORE_DIRECTORY,
dan9e1ab1a2017-01-05 19:32:48 +0000597 /* ePragFlg: */ PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000598 /* ColNames: */ 0, 0,
599 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000600#endif
drhc232aca2016-12-15 16:01:17 +0000601 {/* zName: */ "threads",
602 /* ePragTyp: */ PragTyp_THREADS,
603 /* ePragFlg: */ PragFlg_Result0,
604 /* ColNames: */ 0, 0,
605 /* iArg: */ 0 },
drh2b1c2aa2020-01-07 19:45:40 +0000606#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
607 {/* zName: */ "trusted_schema",
608 /* ePragTyp: */ PragTyp_FLAG,
609 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
610 /* ColNames: */ 0, 0,
611 /* iArg: */ SQLITE_TrustedSchema },
612#endif
drh67e65e52015-02-02 21:34:54 +0000613#if !defined(SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000614 {/* zName: */ "user_version",
615 /* ePragTyp: */ PragTyp_HEADER_VALUE,
dan9e1ab1a2017-01-05 19:32:48 +0000616 /* ePragFlg: */ PragFlg_NoColumns1|PragFlg_Result0,
drhc232aca2016-12-15 16:01:17 +0000617 /* ColNames: */ 0, 0,
618 /* iArg: */ BTREE_USER_VERSION },
drh67e65e52015-02-02 21:34:54 +0000619#endif
620#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
621#if defined(SQLITE_DEBUG)
drhc232aca2016-12-15 16:01:17 +0000622 {/* zName: */ "vdbe_addoptrace",
623 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000624 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000625 /* ColNames: */ 0, 0,
626 /* iArg: */ SQLITE_VdbeAddopTrace },
627 {/* zName: */ "vdbe_debug",
628 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000629 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000630 /* ColNames: */ 0, 0,
631 /* iArg: */ SQLITE_SqlTrace|SQLITE_VdbeListing|SQLITE_VdbeTrace },
632 {/* zName: */ "vdbe_eqp",
633 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000634 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000635 /* ColNames: */ 0, 0,
636 /* iArg: */ SQLITE_VdbeEQP },
637 {/* zName: */ "vdbe_listing",
638 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000639 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000640 /* ColNames: */ 0, 0,
641 /* iArg: */ SQLITE_VdbeListing },
642 {/* zName: */ "vdbe_trace",
643 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000644 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000645 /* ColNames: */ 0, 0,
646 /* iArg: */ SQLITE_VdbeTrace },
drh67e65e52015-02-02 21:34:54 +0000647#endif
648#endif
649#if !defined(SQLITE_OMIT_WAL)
drhc232aca2016-12-15 16:01:17 +0000650 {/* zName: */ "wal_autocheckpoint",
651 /* ePragTyp: */ PragTyp_WAL_AUTOCHECKPOINT,
652 /* ePragFlg: */ 0,
653 /* ColNames: */ 0, 0,
654 /* iArg: */ 0 },
655 {/* zName: */ "wal_checkpoint",
656 /* ePragTyp: */ PragTyp_WAL_CHECKPOINT,
657 /* ePragFlg: */ PragFlg_NeedSchema,
drh2e50f672021-09-21 17:26:23 +0000658 /* ColNames: */ 50, 3,
drhc232aca2016-12-15 16:01:17 +0000659 /* iArg: */ 0 },
drh67e65e52015-02-02 21:34:54 +0000660#endif
661#if !defined(SQLITE_OMIT_FLAG_PRAGMAS)
drhc232aca2016-12-15 16:01:17 +0000662 {/* zName: */ "writable_schema",
663 /* ePragTyp: */ PragTyp_FLAG,
dan9e1ab1a2017-01-05 19:32:48 +0000664 /* ePragFlg: */ PragFlg_Result0|PragFlg_NoColumns1,
drhc232aca2016-12-15 16:01:17 +0000665 /* ColNames: */ 0, 0,
drhfd748c62018-10-30 16:25:35 +0000666 /* iArg: */ SQLITE_WriteSchema|SQLITE_NoSchemaError },
drh67e65e52015-02-02 21:34:54 +0000667#endif
668};
drh2e50f672021-09-21 17:26:23 +0000669/* Number of pragmas: 68 on by default, 78 total. */