~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/schema_dictionary/tests/r/data_dictionary.result

  • Committer: Zimin
  • Date: 2010-07-10 02:51:05 UTC
  • mfrom: (1655 build)
  • mto: (1675.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1677.
  • Revision ID: ziminq@gmail.com-20100710025105-ft7s65oz5td4rmxl
merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
16
16
test
17
17
SELECT COLUMN_NAME  FROM columns;
18
18
COLUMN_NAME
19
 
CHARACTER_SET_NAME
 
19
APPLIER
 
20
AS_LOCATOR
 
21
AUTO_INCREMENT
 
22
AVG_ROW_LENGTH
 
23
Auto_increment
 
24
Avg_row_length
 
25
BLOCKING_LOCK_ID
 
26
BLOCKING_TRX_ID
 
27
CATALOG_NAME
 
28
CHARACTER_MAXIMUM_LENGTH
 
29
CHARACTER_MAXIMUM_LENGTH
 
30
CHARACTER_MAXIMUM_LENGTH
 
31
CHARACTER_MAXIMUM_LENGTH
 
32
CHARACTER_MAXIMUM_LENGTH
 
33
CHARACTER_MAXIMUM_LENGTH
 
34
CHARACTER_OCTET_LENGTH
 
35
CHARACTER_OCTET_LENGTH
 
36
CHARACTER_OCTET_LENGTH
 
37
CHARACTER_OCTET_LENGTH
 
38
CHARACTER_OCTET_LENGTH
 
39
CHARACTER_OCTET_LENGTH
 
40
CHARACTER_OCTET_LENGTH
 
41
CHARACTER_SET_CATALOG
 
42
CHARACTER_SET_CATALOG
 
43
CHARACTER_SET_CATALOG
 
44
CHARACTER_SET_CATALOG
 
45
CHARACTER_SET_CATALOG
 
46
CHARACTER_SET_NAME
 
47
CHARACTER_SET_NAME
 
48
CHARACTER_SET_NAME
 
49
CHARACTER_SET_NAME
 
50
CHARACTER_SET_NAME
 
51
CHARACTER_SET_NAME
 
52
CHARACTER_SET_NAME
 
53
CHARACTER_SET_SCHEMA
 
54
CHARACTER_SET_SCHEMA
 
55
CHARACTER_SET_SCHEMA
 
56
CHARACTER_SET_SCHEMA
 
57
CHARACTER_SET_SCHEMA
 
58
CHECK_CLAUSE
 
59
CHECK_OPTION
 
60
COLLATION_CATALOG
 
61
COLLATION_CATALOG
 
62
COLLATION_CATALOG
 
63
COLLATION_CATALOG
 
64
COLLATION_CATALOG
 
65
COLLATION_NAME
 
66
COLLATION_NAME
 
67
COLLATION_NAME
 
68
COLLATION_NAME
 
69
COLLATION_NAME
 
70
COLLATION_NAME
 
71
COLLATION_NAME
 
72
COLLATION_SCHEMA
 
73
COLLATION_SCHEMA
 
74
COLLATION_SCHEMA
 
75
COLLATION_SCHEMA
 
76
COLLATION_SCHEMA
 
77
COLUMN_COMMENT
 
78
COLUMN_DEFAULT
 
79
COLUMN_DEFAULT
 
80
COLUMN_DEFAULT
 
81
COLUMN_DEFAULT_IS_NULL
 
82
COLUMN_DEFAULT_UPDATE
 
83
COLUMN_NAME
 
84
COLUMN_NAME
 
85
COLUMN_NAME
 
86
COLUMN_NAME
 
87
COLUMN_NAME
 
88
COLUMN_NAME
 
89
COLUMN_NAME
 
90
COLUMN_NAME
 
91
COLUMN_NAME
 
92
COLUMN_NAME
 
93
COLUMN_NUMBER
 
94
COLUMN_TYPE
 
95
COMMAND
 
96
COMPARE_LENGTH
 
97
COMPRESS_OPS
 
98
COMPRESS_OPS
 
99
COMPRESS_OPS_OK
 
100
COMPRESS_OPS_OK
 
101
COMPRESS_TIME
 
102
COMPRESS_TIME
 
103
CONSTRAINT_CATALOG
 
104
CONSTRAINT_CATALOG
 
105
CONSTRAINT_CATALOG
 
106
CONSTRAINT_CATALOG
 
107
CONSTRAINT_CATALOG
 
108
CONSTRAINT_CATALOG
 
109
CONSTRAINT_CATALOG
 
110
CONSTRAINT_NAME
 
111
CONSTRAINT_NAME
 
112
CONSTRAINT_NAME
 
113
CONSTRAINT_NAME
 
114
CONSTRAINT_NAME
 
115
CONSTRAINT_NAME
 
116
CONSTRAINT_NAME
 
117
CONSTRAINT_NAME
 
118
CONSTRAINT_NAME
 
119
CONSTRAINT_SCHEMA
 
120
CONSTRAINT_SCHEMA
 
121
CONSTRAINT_SCHEMA
 
122
CONSTRAINT_SCHEMA
 
123
CONSTRAINT_SCHEMA
 
124
CONSTRAINT_SCHEMA
 
125
CONSTRAINT_SCHEMA
 
126
CONSTRAINT_SCHEMA
 
127
CONSTRAINT_SCHEMA
 
128
CONSTRAINT_TYPE
 
129
CONSTRAINT_TYPE
 
130
COUNT_ADMIN
 
131
COUNT_ADMIN
 
132
COUNT_ALTER
 
133
COUNT_ALTER
 
134
COUNT_COMMIT
 
135
COUNT_COMMIT
 
136
COUNT_CREATE
 
137
COUNT_CREATE
 
138
COUNT_DELETE
 
139
COUNT_DELETE
 
140
COUNT_DROP
 
141
COUNT_DROP
 
142
COUNT_INSERT
 
143
COUNT_INSERT
 
144
COUNT_ROLLBACK
 
145
COUNT_ROLLBACK
 
146
COUNT_SELECT
 
147
COUNT_SELECT
 
148
COUNT_UPDATE
 
149
COUNT_UPDATE
 
150
CREATED
 
151
Column_name
 
152
DATA_TYPE
 
153
DATA_TYPE
 
154
DATA_TYPE
 
155
DATA_TYPE
 
156
DATA_TYPE
 
157
DATA_TYPE
 
158
DATETIME_PRECISION
 
159
DATETIME_PRECISION
 
160
DATETIME_PRECISION
 
161
DATETIME_PRECISION
 
162
DATETIME_PRECISION
 
163
DB
 
164
DEFAULT_CHARACTER_SET_CATALOG
 
165
DEFAULT_CHARACTER_SET_NAME
 
166
DEFAULT_CHARACTER_SET_SCHEMA
20
167
DEFAULT_COLLATE_NAME
21
 
DESCRIPTION
22
 
MAXLEN
23
 
CHARACTER_SET_NAME
24
 
COLLATION_NAME
25
 
DESCRIPTION
26
 
ID
 
168
DEFAULT_COLLATION_NAME
 
169
DELETE_RULE
 
170
DELETE_RULE
 
171
DESCRIPTION
 
172
DESCRIPTION
 
173
DOMAIN_CATALOG
 
174
DOMAIN_CATALOG
 
175
DOMAIN_CATALOG
 
176
DOMAIN_CATALOG
 
177
DOMAIN_CATALOG
 
178
DOMAIN_DEFAULT
 
179
DOMAIN_NAME
 
180
DOMAIN_NAME
 
181
DOMAIN_NAME
 
182
DOMAIN_NAME
 
183
DOMAIN_NAME
 
184
DOMAIN_SCHEMA
 
185
DOMAIN_SCHEMA
 
186
DOMAIN_SCHEMA
 
187
DOMAIN_SCHEMA
 
188
DOMAIN_SCHEMA
 
189
DTD_IDENTIFIER
 
190
Default
 
191
Default_is_NULL
 
192
ENGINE
 
193
ENGINE
 
194
EXTERNAL_LANGUAGE
 
195
EXTERNAL_NAME
 
196
Engine
 
197
Field
 
198
GRANTEE
 
199
GRANTEE
 
200
GRANTOR
 
201
GRANTOR
 
202
HOST
 
203
ID
 
204
ID
 
205
INDEXES_FOUND_IN
 
206
INDEX_COMMENT
 
207
INDEX_NAME
 
208
INDEX_NAME
 
209
INDEX_TYPE
 
210
INFO
 
211
INITIALLY_DEFERRED
 
212
INITIALLY_DEFERRED
 
213
INTERVAL_PRECISION
 
214
INTERVAL_PRECISION
 
215
INTERVAL_TYPE
 
216
INTERVAL_TYPE
 
217
IP
 
218
IS_ACTIVE
 
219
IS_BUILTIN
 
220
IS_COMPILED
27
221
IS_DEFAULT
28
 
IS_COMPILED
29
 
SORTLEN
30
 
TABLE_SCHEMA
31
 
TABLE_NAME
32
 
COLUMN_NAME
33
 
COLUMN_TYPE
34
 
ORDINAL_POSITION
35
 
COLUMN_DEFAULT
36
 
COLUMN_DEFAULT_IS_NULL
37
 
COLUMN_DEFAULT_UPDATE
38
 
IS_NULLABLE
 
222
IS_DEFERRABLE
 
223
IS_DEFERRABLE
 
224
IS_DETERMINISTIC
 
225
IS_FIRST_IN_MULTI
 
226
IS_GRANTABLE
 
227
IS_GRANTABLE
 
228
IS_IMPLICITLY_INVOCABLE
39
229
IS_INDEXED
40
 
IS_USED_IN_PRIMARY
41
 
IS_UNIQUE
42
230
IS_MULTI
43
 
IS_FIRST_IN_MULTI
44
 
INDEXES_FOUND_IN
45
 
DATA_TYPE
46
 
CHARACTER_MAXIMUM_LENGTH
47
 
CHARACTER_OCTET_LENGTH
48
 
NUMERIC_PRECISION
49
 
NUMERIC_SCALE
50
 
COLLATION_NAME
51
 
COLUMN_COMMENT
52
 
USER
53
 
COUNT_SELECT
54
 
COUNT_DELETE
55
 
COUNT_UPDATE
56
 
COUNT_INSERT
57
 
COUNT_ROLLBACK
58
 
COUNT_COMMIT
59
 
COUNT_CREATE
60
 
COUNT_ALTER
61
 
COUNT_DROP
62
 
COUNT_ADMIN
63
 
USER
64
 
IP
65
 
COUNT_SELECT
66
 
COUNT_DELETE
67
 
COUNT_UPDATE
68
 
COUNT_INSERT
69
 
COUNT_ROLLBACK
70
 
COUNT_COMMIT
71
 
COUNT_CREATE
72
 
COUNT_ALTER
73
 
COUNT_DROP
74
 
COUNT_ADMIN
75
 
VARIABLE_NAME
76
 
VARIABLE_VALUE
77
 
VARIABLE_NAME
78
 
VARIABLE_VALUE
79
 
VARIABLE_NAME
80
 
VARIABLE_VALUE
81
 
TABLE_SCHEMA
82
 
TABLE_NAME
83
 
INDEX_NAME
84
 
IS_USED_IN_PRIMARY
85
 
IS_UNIQUE
86
 
IS_NULLABLE
 
231
IS_NAME_LOCKED
 
232
IS_NAME_LOCKED
 
233
IS_NULLABLE
 
234
IS_NULLABLE
 
235
IS_NULLABLE
 
236
IS_NULLABLE
 
237
IS_NULLABLE
 
238
IS_NULL_CALL
 
239
IS_ORDER_REVERSE
 
240
IS_RESULT
 
241
IS_UNIQUE
 
242
IS_UNIQUE
 
243
IS_UNIQUE
 
244
IS_UPDATABLE
 
245
IS_USED_IN_PRIMARY
 
246
IS_USED_IN_PRIMARY
 
247
IS_USED_IN_PRIMARY
 
248
IS_USER_DEFINED_CAST
87
249
KEY_LENGTH
88
 
INDEX_TYPE
89
 
INDEX_COMMENT
90
 
TABLE_SCHEMA
91
 
TABLE_NAME
92
 
INDEX_NAME
93
 
COLUMN_NAME
94
 
COLUMN_NUMBER
95
 
SEQUENCE_IN_INDEX
96
 
COMPARE_LENGTH
97
 
IS_ORDER_REVERSE
98
 
IS_USED_IN_PRIMARY
99
 
IS_UNIQUE
100
 
IS_NULLABLE
101
 
PAGE_SIZE
102
 
COMPRESS_OPS
103
 
COMPRESS_OPS_OK
104
 
COMPRESS_TIME
105
 
UNCOMPRESS_OPS
106
 
UNCOMPRESS_TIME
107
 
PAGE_SIZE
108
 
PAGES_USED
109
 
PAGES_FREE
110
 
RELOCATION_OPS
111
 
RELOCATION_TIME
112
 
PAGE_SIZE
113
 
PAGES_USED
114
 
PAGES_FREE
115
 
RELOCATION_OPS
116
 
RELOCATION_TIME
117
 
PAGE_SIZE
118
 
COMPRESS_OPS
119
 
COMPRESS_OPS_OK
120
 
COMPRESS_TIME
121
 
UNCOMPRESS_OPS
122
 
UNCOMPRESS_TIME
123
 
TABLE_NAME
 
250
Key_name
 
251
LAST_ALTERED
 
252
LOCK_DATA
124
253
LOCK_ID
125
 
LOCK_TRX_ID
 
254
LOCK_INDEX
126
255
LOCK_MODE
127
 
LOCK_TYPE
128
 
LOCK_TABLE
129
 
LOCK_INDEX
130
 
LOCK_SPACE
131
256
LOCK_PAGE
132
257
LOCK_REC
133
 
LOCK_DATA
134
 
REQUESTING_TRX_ID
135
 
REQUESTED_LOCK_ID
136
 
BLOCKING_TRX_ID
137
 
BLOCKING_LOCK_ID
138
 
VARIABLE_NAME
139
 
VARIABLE_VALUE
140
 
TRX_ID
141
 
TRX_STATE
142
 
TRX_STARTED
143
 
TRX_REQUESTED_LOCK_ID
144
 
TRX_WAIT_STARTED
145
 
TRX_WEIGHT
146
 
TRX_DRIZZLE_THREAD_ID
147
 
TRX_QUERY
148
 
MODULE_NAME
149
 
MODULE_VERSION
 
258
LOCK_SPACE
 
259
LOCK_TABLE
 
260
LOCK_TRX_ID
 
261
LOCK_TYPE
 
262
MATCH_OPTION
 
263
MATCH_OPTION
 
264
MAXIMUM_CARDINALITY
 
265
MAXLEN
 
266
MAX_DYNAMIC_RESULT_SETS
150
267
MODULE_AUTHOR
151
 
IS_BUILTIN
 
268
MODULE_CATALOG
 
269
MODULE_DESCRIPTION
152
270
MODULE_LIBRARY
153
 
MODULE_DESCRIPTION
154
271
MODULE_LICENSE
 
272
MODULE_NAME
 
273
MODULE_NAME
 
274
MODULE_NAME
 
275
MODULE_SCHEMA
 
276
MODULE_VERSION
 
277
NUMERIC_PRECISION
 
278
NUMERIC_PRECISION
 
279
NUMERIC_PRECISION
 
280
NUMERIC_PRECISION
 
281
NUMERIC_PRECISION
 
282
NUMERIC_PRECISION
 
283
NUMERIC_PRECISION_RADIX
 
284
NUMERIC_PRECISION_RADIX
 
285
NUMERIC_PRECISION_RADIX
 
286
NUMERIC_PRECISION_RADIX
 
287
NUMERIC_PRECISION_RADIX
 
288
NUMERIC_SCALE
 
289
NUMERIC_SCALE
 
290
NUMERIC_SCALE
 
291
NUMERIC_SCALE
 
292
NUMERIC_SCALE
 
293
NUMERIC_SCALE
 
294
Name
 
295
Null
 
296
ORDINAL_POSITION
 
297
ORDINAL_POSITION
 
298
ORDINAL_POSITION
 
299
ORDINAL_POSITION
 
300
ORDINAL_POSITION
 
301
On_Update
 
302
PAGES_FREE
 
303
PAGES_FREE
 
304
PAGES_USED
 
305
PAGES_USED
 
306
PAGE_SIZE
 
307
PAGE_SIZE
 
308
PAGE_SIZE
 
309
PAGE_SIZE
 
310
PARAMETER_MODE
 
311
PARAMETER_NAME
 
312
PARAMETER_STYLE
155
313
PLUGIN_NAME
156
314
PLUGIN_TYPE
157
 
IS_ACTIVE
158
 
MODULE_NAME
159
 
ID
160
 
USER
161
 
HOST
162
 
DB
163
 
COMMAND
164
 
TIME
165
 
STATE
166
 
INFO
167
 
CONSTRAINT_SCHEMA
168
 
CONSTRAINT_NAME
169
 
UNIQUE_CONSTRAINT_SCHEMA
170
 
UNIQUE_CONSTRAINT_NAME
171
 
MATCH_OPTION
172
 
UPDATE_RULE
173
 
DELETE_RULE
174
 
TABLE_NAME
 
315
PRIVILEGE_TYPE
 
316
PRIVILEGE_TYPE
 
317
RECORDS
 
318
RECORD_LENGTH
175
319
REFERENCED_TABLE_NAME
 
320
RELOCATION_OPS
 
321
RELOCATION_OPS
 
322
RELOCATION_TIME
 
323
RELOCATION_TIME
176
324
REPLICATOR
177
 
APPLIER
178
 
SCHEMA_NAME
179
 
DEFAULT_COLLATION_NAME
 
325
REQUESTED_LOCK_ID
 
326
REQUESTING_TRX_ID
 
327
ROUTINE_BODY
 
328
ROUTINE_CATALOG
 
329
ROUTINE_DEFINITION
 
330
ROUTINE_NAME
 
331
ROUTINE_SCHEMA
 
332
ROWS
 
333
ROW_FORMAT
 
334
Rows
180
335
SCHEMA_CREATION_TIME
 
336
SCHEMA_LEVEL_ROUTINE
 
337
SCHEMA_NAME
 
338
SCHEMA_NAME
 
339
SCHEMA_NAME
 
340
SCHEMA_OWNER
181
341
SCHEMA_UPDATE_TIME
182
 
VARIABLE_NAME
183
 
VARIABLE_VALUE
184
 
VARIABLE_NAME
185
 
VARIABLE_VALUE
186
 
VARIABLE_NAME
187
 
VARIABLE_VALUE
188
 
Field
189
 
Type
190
 
Null
191
 
Default
192
 
Default_is_NULL
193
 
On_Update
194
 
Table
195
 
Unique
196
 
Key_name
 
342
SCOPE_CATALOG
 
343
SCOPE_CATALOG
 
344
SCOPE_NAME
 
345
SCOPE_NAME
 
346
SCOPE_SCHEMA
 
347
SCOPE_SCHEMA
 
348
SEQUENCE_IN_INDEX
 
349
SESSION_ID
 
350
SORTLEN
 
351
SPECIFIC_CATALOG
 
352
SPECIFIC_CATALOG
 
353
SPECIFIC_NAME
 
354
SPECIFIC_NAME
 
355
SPECIFIC_SCHEMA
 
356
SPECIFIC_SCHEMA
 
357
SQL_DATA_ACCESS
 
358
SQL_PATH
 
359
STATE
 
360
Schema
197
361
Seq_in_index
198
 
Column_name
199
 
SCHEMA_NAME
200
 
TABLE_NAME
201
362
Session
202
 
Schema
203
 
Name
204
 
Type
205
 
Engine
206
 
Version
207
 
Rows
208
 
Avg_row_length
209
 
Table_size
210
 
Auto_increment
211
 
TABLE_SCHEMA
212
 
TABLE_NAME
213
 
RECORDS
214
 
RECORD_LENGTH
215
 
ENGINE
216
 
TABLE_SCHEMA
217
 
TABLE_NAME
218
 
TABLE_TYPE
219
 
ENGINE
220
 
ROW_FORMAT
 
363
TABLE_CATALOG
 
364
TABLE_CATALOG
 
365
TABLE_CATALOG
 
366
TABLE_CATALOG
 
367
TABLE_CATALOG
 
368
TABLE_CATALOG
 
369
TABLE_CATALOG
 
370
TABLE_CATALOG
 
371
TABLE_CATALOG
 
372
TABLE_CATALOG
 
373
TABLE_CATALOG
 
374
TABLE_CATALOG
 
375
TABLE_CATALOG
 
376
TABLE_CATALOG
221
377
TABLE_COLLATION
 
378
TABLE_COMMENT
 
379
TABLE_COUNT
222
380
TABLE_CREATION_TIME
 
381
TABLE_NAME
 
382
TABLE_NAME
 
383
TABLE_NAME
 
384
TABLE_NAME
 
385
TABLE_NAME
 
386
TABLE_NAME
 
387
TABLE_NAME
 
388
TABLE_NAME
 
389
TABLE_NAME
 
390
TABLE_NAME
 
391
TABLE_NAME
 
392
TABLE_NAME
 
393
TABLE_NAME
 
394
TABLE_NAME
 
395
TABLE_NAME
 
396
TABLE_NAME
 
397
TABLE_NAME
 
398
TABLE_NAME
 
399
TABLE_NAME
 
400
TABLE_NAME
 
401
TABLE_NAME
 
402
TABLE_NAME
 
403
TABLE_NAME
 
404
TABLE_NAME
 
405
TABLE_NAME
 
406
TABLE_SCHEMA
 
407
TABLE_SCHEMA
 
408
TABLE_SCHEMA
 
409
TABLE_SCHEMA
 
410
TABLE_SCHEMA
 
411
TABLE_SCHEMA
 
412
TABLE_SCHEMA
 
413
TABLE_SCHEMA
 
414
TABLE_SCHEMA
 
415
TABLE_SCHEMA
 
416
TABLE_SCHEMA
 
417
TABLE_SCHEMA
 
418
TABLE_SCHEMA
 
419
TABLE_SCHEMA
 
420
TABLE_SCHEMA
 
421
TABLE_SCHEMA
 
422
TABLE_SCHEMA
 
423
TABLE_SCHEMA
 
424
TABLE_SCHEMA
 
425
TABLE_SCHEMA
 
426
TABLE_SCHEMA
 
427
TABLE_SCHEMA
 
428
TABLE_SIZE
 
429
TABLE_TYPE
 
430
TABLE_TYPE
223
431
TABLE_UPDATE_TIME
224
 
TABLE_COMMENT
225
 
SESSION_ID
226
 
TABLE_SCHEMA
227
 
TABLE_NAME
228
 
VERSION
229
 
IS_NAME_LOCKED
230
 
ROWS
231
 
AVG_ROW_LENGTH
232
 
TABLE_SIZE
233
 
AUTO_INCREMENT
234
 
CONSTRAINT_SCHEMA
235
 
CONSTRAINT_NAME
236
 
TABLE_SCHEMA
237
 
TABLE_NAME
238
 
CONSTRAINT_TYPE
239
 
TABLE_SCHEMA
240
 
TABLE_NAME
241
 
VERSION
242
 
TABLE_COUNT
243
 
IS_NAME_LOCKED
244
 
CONSTRAINT_CATALOG
245
 
CONSTRAINT_SCHEMA
246
 
CONSTRAINT_NAME
247
 
CHECK_CLAUSE
248
 
TABLE_CATALOG
249
 
TABLE_SCHEMA
250
 
TABLE_NAME
251
 
COLUMN_NAME
252
 
ORDINAL_POSITION
253
 
COLUMN_DEFAULT
254
 
IS_NULLABLE
255
 
DATA_TYPE
256
 
CHARACTER_MAXIMUM_LENGTH
257
 
CHARACTER_OCTET_LENGTH
258
 
NUMERIC_PRECISION
259
 
NUMERIC_PRECISION_RADIX
260
 
NUMERIC_SCALE
261
 
DATETIME_PRECISION
262
 
CHARACTER_SET_CATALOG
263
 
CHARACTER_SET_SCHEMA
264
 
CHARACTER_SET_NAME
265
 
COLLATION_CATALOG
266
 
COLLATION_SCHEMA
267
 
COLLATION_NAME
268
 
DOMAIN_CATALOG
269
 
DOMAIN_SCHEMA
270
 
DOMAIN_NAME
271
 
DOMAIN_CATALOG
272
 
DOMAIN_SCHEMA
273
 
DOMAIN_NAME
274
 
TABLE_CATALOG
275
 
TABLE_SCHEMA
276
 
TABLE_NAME
277
 
COLUMN_NAME
278
 
GRANTOR
279
 
GRANTEE
280
 
TABLE_CATALOG
281
 
TABLE_SCHEMA
282
 
TABLE_NAME
283
 
COLUMN_NAME
284
 
PRIVILEGE_TYPE
285
 
IS_GRANTABLE
286
 
TABLE_CATALOG
287
 
TABLE_SCHEMA
288
 
TABLE_NAME
289
 
COLUMN_NAME
290
 
CONSTRAINT_CATALOG
291
 
CONSTRAINT_SCHEMA
292
 
CONSTRAINT_NAME
293
 
TABLE_CATALOG
294
 
TABLE_SCHEMA
295
 
TABLE_NAME
296
 
CONSTRAINT_CATALOG
297
 
CONSTRAINT_SCHEMA
298
 
CONSTRAINT_NAME
299
 
DOMAIN_CATALOG
300
 
DOMAIN_SCHEMA
301
 
DOMAIN_NAME
302
 
DATA_TYPE
303
 
CHARACTER_MAXIMUM_LENGTH
304
 
CHARACTER_OCTET_LENGTH
305
 
COLLATION_CATALOG
306
 
COLLATION_SCHEMA
307
 
COLLATION_NAME
308
 
CHARACTER_SET_CATALOG
309
 
CHARACTER_SET_SCHEMA
310
 
CHARACTER_SET_NAME
311
 
NUMERIC_PRECISION
312
 
NUMERIC_PRECISION_RADIX
313
 
NUMERIC_SCALE
314
 
DATETIME_PRECISION
315
 
DOMAIN_DEFAULT
316
 
CONSTRAINT_CATALOG
317
 
CONSTRAINT_SCHEMA
318
 
CONSTRAINT_NAME
319
 
DOMAIN_CATALOG
320
 
DOMAIN_SCHEMA
321
 
DOMAIN_NAME
322
 
IS_DEFERRABLE
323
 
INITIALLY_DEFERRED
324
 
CONSTRAINT_CATALOG
325
 
CONSTRAINT_SCHEMA
326
 
CONSTRAINT_NAME
327
 
TABLE_CATALOG
328
 
TABLE_SCHEMA
329
 
TABLE_NAME
330
 
COLUMN_NAME
331
 
ORDINAL_POSITION
332
 
SPECIFIC_CATALOG
333
 
SPECIFIC_SCHEMA
334
 
SPECIFIC_NAME
335
 
ORDINAL_POSITION
336
 
PARAMETER_MODE
337
 
IS_RESULT
338
 
AS_LOCATOR
339
 
PARAMETER_NAME
340
 
DATA_TYPE
341
 
CHARACTER_MAXIMUM_LENGTH
342
 
CHARACTER_OCTET_LENGTH
343
 
CHARACTER_OCTET_LENGTH
344
 
COLLATION_CATALOG
345
 
COLLATION_SCHEMA
346
 
COLLATION_NAME
347
 
CHARACTER_SET_CATALOG
348
 
CHARACTER_SET_SCHEMA
349
 
CHARACTER_SET_NAME
350
 
NUMERIC_PRECISION
351
 
NUMERIC_PRECISION_RADIX
352
 
NUMERIC_SCALE
353
 
DATETIME_PRECISION
354
 
INTERVAL_TYPE
355
 
INTERVAL_PRECISION
 
432
TIME
 
433
TRX_DRIZZLE_THREAD_ID
 
434
TRX_ID
 
435
TRX_QUERY
 
436
TRX_REQUESTED_LOCK_ID
 
437
TRX_STARTED
 
438
TRX_STATE
 
439
TRX_WAIT_STARTED
 
440
TRX_WEIGHT
 
441
TYPE_UDT_CATALOG
 
442
TYPE_UDT_NAME
 
443
TYPE_UDT_SCHEMA
 
444
Table
 
445
Table_size
 
446
Type
 
447
Type
 
448
UDT_CATALOG
 
449
UDT_NAME
 
450
UDT_SCHEMA
 
451
UNCOMPRESS_OPS
 
452
UNCOMPRESS_OPS
 
453
UNCOMPRESS_TIME
 
454
UNCOMPRESS_TIME
 
455
UNIQUE_CONSTRAINT_CATALOG
 
456
UNIQUE_CONSTRAINT_NAME
 
457
UNIQUE_CONSTRAINT_NAME
 
458
UNIQUE_CONSTRAINT_SCHEMA
 
459
UNIQUE_CONSTRAINT_SCHEMA
 
460
UPDATE_RULE
 
461
UPDATE_RULE
 
462
USER
 
463
USER
 
464
USER
356
465
USER_DEFINED_TYPE_CATALOG
 
466
USER_DEFINED_TYPE_NAME
357
467
USER_DEFINED_TYPE_SCHEMA
358
 
USER_DEFINED_TYPE_NAME
359
 
SCOPE_CATALOG
360
 
SCOPE_SCHEMA
361
 
SCOPE_NAME
362
 
CONSTRAINT_CATALOG
363
 
CONSTRAINT_SCHEMA
364
 
CONSTRAINT_NAME
365
 
UNIQUE_CONSTRAINT_CATALOG
366
 
UNIQUE_CONSTRAINT_SCHEMA
367
 
UNIQUE_CONSTRAINT_NAME
368
 
MATCH_OPTION
369
 
UPDATE_RULE
370
 
DELETE_RULE
371
 
SPECIFIC_CATALOG
372
 
SPECIFIC_SCHEMA
373
 
SPECIFIC_NAME
374
 
ROUTINE_CATALOG
375
 
ROUTINE_SCHEMA
376
 
ROUTINE_NAME
377
 
MODULE_CATALOG
378
 
MODULE_SCHEMA
379
 
MODULE_NAME
380
 
UDT_CATALOG
381
 
UDT_SCHEMA
382
 
UDT_NAME
383
 
DATA_TYPE
384
 
CHARACTER_MAXIMUM_LENGTH
385
 
CHARACTER_OCTET_LENGTH
386
 
COLLATION_CATALOG
387
 
COLLATION_SCHEMA
388
 
COLLATION_NAME
389
 
CHARACTER_SET_CATALOG
390
 
CHARACTER_SET_SCHEMA
391
 
CHARACTER_SET_NAME
392
 
TABLE_CATALOG
393
 
TABLE_SCHEMA
394
 
TABLE_NAME
395
 
NUMERIC_PRECISION
396
 
NUMERIC_PRECISION_RADIX
397
 
NUMERIC_SCALE
398
 
DATETIME_PRECISION
399
 
INTERVAL_TYPE
400
 
INTERVAL_PRECISION
401
 
TYPE_UDT_CATALOG
402
 
TYPE_UDT_SCHEMA
403
 
TYPE_UDT_NAME
404
 
SCOPE_CATALOG
405
 
SCOPE_SCHEMA
406
 
SCOPE_NAME
407
 
MAXIMUM_CARDINALITY
408
 
DTD_IDENTIFIER
409
 
ROUTINE_BODY
410
 
ROUTINE_DEFINITION
411
 
EXTERNAL_NAME
412
 
EXTERNAL_LANGUAGE
413
 
PARAMETER_STYLE
414
 
IS_DETERMINISTIC
415
 
SQL_DATA_ACCESS
416
 
IS_NULL_CALL
417
 
SQL_PATH
418
 
SCHEMA_LEVEL_ROUTINE
419
 
MAX_DYNAMIC_RESULT_SETS
420
 
IS_USER_DEFINED_CAST
421
 
IS_IMPLICITLY_INVOCABLE
422
 
CREATED
423
 
LAST_ALTERED
424
 
TABLE_CATALOG
425
 
TABLE_SCHEMA
426
 
TABLE_NAME
427
 
COLUMN_NAME
428
 
ORDINAL_POSITION
429
 
COLUMN_DEFAULT
430
 
IS_NULLABLE
431
 
DATA_TYPE
432
 
CHARACTER_MAXIMUM_LENGTH
433
 
CHARACTER_OCTET_LENGTH
434
 
NUMERIC_PRECISION
435
 
NUMERIC_PRECISION_RADIX
436
 
NUMERIC_SCALE
437
 
DATETIME_PRECISION
438
 
CHARACTER_SET_CATALOG
439
 
CHARACTER_SET_SCHEMA
440
 
CHARACTER_SET_NAME
441
 
COLLATION_CATALOG
442
 
COLLATION_SCHEMA
443
 
COLLATION_NAME
444
 
DOMAIN_CATALOG
445
 
DOMAIN_SCHEMA
446
 
DOMAIN_NAME
447
 
CATALOG_NAME
448
 
SCHEMA_NAME
449
 
SCHEMA_OWNER
450
 
DEFAULT_CHARACTER_SET_CATALOG
451
 
DEFAULT_CHARACTER_SET_SCHEMA
452
 
DEFAULT_CHARACTER_SET_NAME
453
 
TABLE_CATALOG
454
 
TABLE_SCHEMA
455
 
TABLE_NAME
456
 
TABLE_TYPE
457
 
CONSTRAINT_CATALOG
458
 
CONSTRAINT_SCHEMA
459
 
CONSTRAINT_NAME
460
 
TABLE_CATALOG
461
 
TABLE_SCHEMA
462
 
TABLE_NAME
463
 
CONSTRAINT_TYPE
464
 
IS_DEFERRABLE
465
 
INITIALLY_DEFERRED
466
 
GRANTOR
467
 
GRANTEE
468
 
TABLE_CATALOG
469
 
TABLE_SCHEMA
470
 
TABLE_NAME
471
 
COLUMN_NAME
472
 
PRIVILEGE_TYPE
473
 
IS_GRANTABLE
474
 
VIEW_CATALOG
475
 
VIEW_SCHEMA
476
 
VIEW_NAME
477
 
TABLE_CATALOG
478
 
TABLE_SCHEMA
479
 
TABLE_NAME
480
 
VIEW_CATALOG
481
 
VIEW_SCHEMA
482
 
VIEW_NAME
483
 
TABLE_CATALOG
484
 
TABLE_SCHEMA
485
 
TABLE_NAME
486
 
COLUMN_NAME
487
 
TABLE_CATALOG
488
 
TABLE_SCHEMA
489
 
TABLE_NAME
 
468
Unique
 
469
VARIABLE_NAME
 
470
VARIABLE_NAME
 
471
VARIABLE_NAME
 
472
VARIABLE_NAME
 
473
VARIABLE_NAME
 
474
VARIABLE_NAME
 
475
VARIABLE_NAME
 
476
VARIABLE_VALUE
 
477
VARIABLE_VALUE
 
478
VARIABLE_VALUE
 
479
VARIABLE_VALUE
 
480
VARIABLE_VALUE
 
481
VARIABLE_VALUE
 
482
VARIABLE_VALUE
 
483
VERSION
 
484
VERSION
 
485
VIEW_CATALOG
 
486
VIEW_CATALOG
490
487
VIEW_DEFINITION
491
 
CHECK_OPTION
492
 
IS_UPDATABLE
 
488
VIEW_NAME
 
489
VIEW_NAME
 
490
VIEW_SCHEMA
 
491
VIEW_SCHEMA
 
492
Version
493
493
SELECT count(*) FROM REFERENTIAL_CONSTRAINTS;
494
494
count(*)
495
495
0
515
515
  `IS_FIRST_IN_MULTI` varchar(5) NOT NULL DEFAULT '',
516
516
  `INDEXES_FOUND_IN` bigint NOT NULL DEFAULT '0',
517
517
  `DATA_TYPE` varchar(256) NOT NULL DEFAULT '',
518
 
  `CHARACTER_MAXIMUM_LENGTH` bigint NOT NULL DEFAULT '0',
519
 
  `CHARACTER_OCTET_LENGTH` bigint NOT NULL DEFAULT '0',
520
 
  `NUMERIC_PRECISION` bigint NOT NULL DEFAULT '0',
521
 
  `NUMERIC_SCALE` bigint NOT NULL DEFAULT '0',
 
518
  `CHARACTER_MAXIMUM_LENGTH` bigint DEFAULT NULL,
 
519
  `CHARACTER_OCTET_LENGTH` bigint DEFAULT NULL,
 
520
  `NUMERIC_PRECISION` bigint DEFAULT NULL,
 
521
  `NUMERIC_SCALE` bigint DEFAULT NULL,
522
522
  `COLLATION_NAME` varchar(256) NOT NULL DEFAULT '',
523
523
  `COLUMN_COMMENT` varchar(1024) DEFAULT NULL
524
524
) ENGINE=FunctionEngine
602
602
use data_dictionary;
603
603
SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
604
604
TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME
605
 
a       a       a
606
605
DATA_DICTIONARY CHARACTER_SETS  CHARACTER_SET_NAME
607
606
DATA_DICTIONARY CHARACTER_SETS  DEFAULT_COLLATE_NAME
608
607
DATA_DICTIONARY CHARACTER_SETS  DESCRIPTION
1077
1076
INFORMATION_SCHEMA      VIEW_TABLE_USAGE        TABLE_NAME
1078
1077
INFORMATION_SCHEMA      VIEW_TABLE_USAGE        TABLE_SCHEMA
1079
1078
INFORMATION_SCHEMA      VIEW_TABLE_USAGE        VIEW_DEFINITION
 
1079
a       a       a
1080
1080
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
1081
1081
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
1082
 
a       a       a
1083
1082
CHARACTER_SETS  DATA_DICTIONARY CHARACTER_SET_NAME
1084
1083
CHARACTER_SETS  DATA_DICTIONARY DEFAULT_COLLATE_NAME
1085
1084
CHARACTER_SETS  DATA_DICTIONARY DESCRIPTION
1086
1085
CHARACTER_SETS  DATA_DICTIONARY MAXLEN
 
1086
CHECK_CONSTRAINTS       INFORMATION_SCHEMA      CHECK_CLAUSE
 
1087
CHECK_CONSTRAINTS       INFORMATION_SCHEMA      CONSTRAINT_CATALOG
 
1088
CHECK_CONSTRAINTS       INFORMATION_SCHEMA      CONSTRAINT_NAME
 
1089
CHECK_CONSTRAINTS       INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
1087
1090
COLLATIONS      DATA_DICTIONARY CHARACTER_SET_NAME
1088
1091
COLLATIONS      DATA_DICTIONARY COLLATION_NAME
1089
1092
COLLATIONS      DATA_DICTIONARY DESCRIPTION
1113
1116
COLUMNS DATA_DICTIONARY ORDINAL_POSITION
1114
1117
COLUMNS DATA_DICTIONARY TABLE_NAME
1115
1118
COLUMNS DATA_DICTIONARY TABLE_SCHEMA
 
1119
COLUMNS INFORMATION_SCHEMA      CHARACTER_MAXIMUM_LENGTH
 
1120
COLUMNS INFORMATION_SCHEMA      CHARACTER_OCTET_LENGTH
 
1121
COLUMNS INFORMATION_SCHEMA      CHARACTER_SET_CATALOG
 
1122
COLUMNS INFORMATION_SCHEMA      CHARACTER_SET_NAME
 
1123
COLUMNS INFORMATION_SCHEMA      CHARACTER_SET_SCHEMA
 
1124
COLUMNS INFORMATION_SCHEMA      COLLATION_CATALOG
 
1125
COLUMNS INFORMATION_SCHEMA      COLLATION_NAME
 
1126
COLUMNS INFORMATION_SCHEMA      COLLATION_SCHEMA
 
1127
COLUMNS INFORMATION_SCHEMA      COLUMN_DEFAULT
 
1128
COLUMNS INFORMATION_SCHEMA      COLUMN_NAME
 
1129
COLUMNS INFORMATION_SCHEMA      DATA_TYPE
 
1130
COLUMNS INFORMATION_SCHEMA      DATETIME_PRECISION
 
1131
COLUMNS INFORMATION_SCHEMA      DOMAIN_CATALOG
 
1132
COLUMNS INFORMATION_SCHEMA      DOMAIN_NAME
 
1133
COLUMNS INFORMATION_SCHEMA      DOMAIN_SCHEMA
 
1134
COLUMNS INFORMATION_SCHEMA      IS_NULLABLE
 
1135
COLUMNS INFORMATION_SCHEMA      NUMERIC_PRECISION
 
1136
COLUMNS INFORMATION_SCHEMA      NUMERIC_PRECISION_RADIX
 
1137
COLUMNS INFORMATION_SCHEMA      NUMERIC_SCALE
 
1138
COLUMNS INFORMATION_SCHEMA      ORDINAL_POSITION
 
1139
COLUMNS INFORMATION_SCHEMA      TABLE_CATALOG
 
1140
COLUMNS INFORMATION_SCHEMA      TABLE_NAME
 
1141
COLUMNS INFORMATION_SCHEMA      TABLE_SCHEMA
 
1142
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      COLUMN_NAME
 
1143
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      DOMAIN_CATALOG
 
1144
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      DOMAIN_NAME
 
1145
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      DOMAIN_SCHEMA
 
1146
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      TABLE_CATALOG
 
1147
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      TABLE_NAME
 
1148
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      TABLE_SCHEMA
 
1149
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      COLUMN_NAME
 
1150
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      GRANTEE
 
1151
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      GRANTOR
 
1152
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      IS_GRANTABLE
 
1153
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      PRIVILEGE_TYPE
 
1154
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      TABLE_CATALOG
 
1155
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      TABLE_NAME
 
1156
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      TABLE_SCHEMA
 
1157
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      COLUMN_NAME
 
1158
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      CONSTRAINT_CATALOG
 
1159
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      CONSTRAINT_NAME
 
1160
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
 
1161
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      TABLE_CATALOG
 
1162
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      TABLE_NAME
 
1163
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      TABLE_SCHEMA
 
1164
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      CONSTRAINT_CATALOG
 
1165
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      CONSTRAINT_NAME
 
1166
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
 
1167
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_CATALOG
 
1168
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_NAME
 
1169
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_SCHEMA
1116
1170
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ADMIN
1117
1171
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_ALTER
1118
1172
CUMULATIVE_SQL_COMMANDS DATA_DICTIONARY COUNT_COMMIT
1136
1190
CURRENT_SQL_COMMANDS    DATA_DICTIONARY COUNT_UPDATE
1137
1191
CURRENT_SQL_COMMANDS    DATA_DICTIONARY IP
1138
1192
CURRENT_SQL_COMMANDS    DATA_DICTIONARY USER
 
1193
DOMAINS INFORMATION_SCHEMA      CHARACTER_MAXIMUM_LENGTH
 
1194
DOMAINS INFORMATION_SCHEMA      CHARACTER_OCTET_LENGTH
 
1195
DOMAINS INFORMATION_SCHEMA      CHARACTER_SET_CATALOG
 
1196
DOMAINS INFORMATION_SCHEMA      CHARACTER_SET_NAME
 
1197
DOMAINS INFORMATION_SCHEMA      CHARACTER_SET_SCHEMA
 
1198
DOMAINS INFORMATION_SCHEMA      COLLATION_CATALOG
 
1199
DOMAINS INFORMATION_SCHEMA      COLLATION_NAME
 
1200
DOMAINS INFORMATION_SCHEMA      COLLATION_SCHEMA
 
1201
DOMAINS INFORMATION_SCHEMA      DATA_TYPE
 
1202
DOMAINS INFORMATION_SCHEMA      DATETIME_PRECISION
 
1203
DOMAINS INFORMATION_SCHEMA      DOMAIN_CATALOG
 
1204
DOMAINS INFORMATION_SCHEMA      DOMAIN_DEFAULT
 
1205
DOMAINS INFORMATION_SCHEMA      DOMAIN_NAME
 
1206
DOMAINS INFORMATION_SCHEMA      DOMAIN_SCHEMA
 
1207
DOMAINS INFORMATION_SCHEMA      NUMERIC_PRECISION
 
1208
DOMAINS INFORMATION_SCHEMA      NUMERIC_PRECISION_RADIX
 
1209
DOMAINS INFORMATION_SCHEMA      NUMERIC_SCALE
 
1210
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      CONSTRAINT_CATALOG
 
1211
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      CONSTRAINT_NAME
 
1212
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
 
1213
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      DOMAIN_CATALOG
 
1214
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      DOMAIN_NAME
 
1215
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      DOMAIN_SCHEMA
 
1216
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      INITIALLY_DEFERRED
 
1217
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      IS_DEFERRABLE
1139
1218
GLOBAL_STATEMENTS       DATA_DICTIONARY VARIABLE_NAME
1140
1219
GLOBAL_STATEMENTS       DATA_DICTIONARY VARIABLE_VALUE
1141
1220
GLOBAL_STATUS   DATA_DICTIONARY VARIABLE_NAME
1209
1288
INNODB_TRX      DATA_DICTIONARY TRX_STATE
1210
1289
INNODB_TRX      DATA_DICTIONARY TRX_WAIT_STARTED
1211
1290
INNODB_TRX      DATA_DICTIONARY TRX_WEIGHT
1212
 
MODULES DATA_DICTIONARY IS_BUILTIN
1213
 
MODULES DATA_DICTIONARY MODULE_AUTHOR
1214
 
MODULES DATA_DICTIONARY MODULE_DESCRIPTION
1215
 
MODULES DATA_DICTIONARY MODULE_LIBRARY
1216
 
MODULES DATA_DICTIONARY MODULE_LICENSE
1217
 
MODULES DATA_DICTIONARY MODULE_NAME
1218
 
MODULES DATA_DICTIONARY MODULE_VERSION
1219
 
PLUGINS DATA_DICTIONARY IS_ACTIVE
1220
 
PLUGINS DATA_DICTIONARY MODULE_NAME
1221
 
PLUGINS DATA_DICTIONARY PLUGIN_NAME
1222
 
PLUGINS DATA_DICTIONARY PLUGIN_TYPE
1223
 
PROCESSLIST     DATA_DICTIONARY COMMAND
1224
 
PROCESSLIST     DATA_DICTIONARY DB
1225
 
PROCESSLIST     DATA_DICTIONARY HOST
1226
 
PROCESSLIST     DATA_DICTIONARY ID
1227
 
PROCESSLIST     DATA_DICTIONARY INFO
1228
 
PROCESSLIST     DATA_DICTIONARY STATE
1229
 
PROCESSLIST     DATA_DICTIONARY TIME
1230
 
PROCESSLIST     DATA_DICTIONARY USER
1231
 
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_NAME
1232
 
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_SCHEMA
1233
 
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY DELETE_RULE
1234
 
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY MATCH_OPTION
1235
 
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY REFERENCED_TABLE_NAME
1236
 
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY TABLE_NAME
1237
 
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY UNIQUE_CONSTRAINT_NAME
1238
 
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY UNIQUE_CONSTRAINT_SCHEMA
1239
 
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY UPDATE_RULE
1240
 
REPLICATION_STREAMS     DATA_DICTIONARY APPLIER
1241
 
REPLICATION_STREAMS     DATA_DICTIONARY REPLICATOR
1242
 
SCHEMAS DATA_DICTIONARY DEFAULT_COLLATION_NAME
1243
 
SCHEMAS DATA_DICTIONARY SCHEMA_CREATION_TIME
1244
 
SCHEMAS DATA_DICTIONARY SCHEMA_NAME
1245
 
SCHEMAS DATA_DICTIONARY SCHEMA_UPDATE_TIME
1246
 
SESSION_STATEMENTS      DATA_DICTIONARY VARIABLE_NAME
1247
 
SESSION_STATEMENTS      DATA_DICTIONARY VARIABLE_VALUE
1248
 
SESSION_STATUS  DATA_DICTIONARY VARIABLE_NAME
1249
 
SESSION_STATUS  DATA_DICTIONARY VARIABLE_VALUE
1250
 
SESSION_VARIABLES       DATA_DICTIONARY VARIABLE_NAME
1251
 
SESSION_VARIABLES       DATA_DICTIONARY VARIABLE_VALUE
1252
 
SHOW_COLUMNS    DATA_DICTIONARY Default
1253
 
SHOW_COLUMNS    DATA_DICTIONARY Default_is_NULL
1254
 
SHOW_COLUMNS    DATA_DICTIONARY Field
1255
 
SHOW_COLUMNS    DATA_DICTIONARY Null
1256
 
SHOW_COLUMNS    DATA_DICTIONARY On_Update
1257
 
SHOW_COLUMNS    DATA_DICTIONARY Type
1258
 
SHOW_INDEXES    DATA_DICTIONARY Column_name
1259
 
SHOW_INDEXES    DATA_DICTIONARY Key_name
1260
 
SHOW_INDEXES    DATA_DICTIONARY Seq_in_index
1261
 
SHOW_INDEXES    DATA_DICTIONARY Table
1262
 
SHOW_INDEXES    DATA_DICTIONARY Unique
1263
 
SHOW_SCHEMAS    DATA_DICTIONARY SCHEMA_NAME
1264
 
SHOW_TABLES     DATA_DICTIONARY TABLE_NAME
1265
 
SHOW_TABLE_STATUS       DATA_DICTIONARY Auto_increment
1266
 
SHOW_TABLE_STATUS       DATA_DICTIONARY Avg_row_length
1267
 
SHOW_TABLE_STATUS       DATA_DICTIONARY Engine
1268
 
SHOW_TABLE_STATUS       DATA_DICTIONARY Name
1269
 
SHOW_TABLE_STATUS       DATA_DICTIONARY Rows
1270
 
SHOW_TABLE_STATUS       DATA_DICTIONARY Schema
1271
 
SHOW_TABLE_STATUS       DATA_DICTIONARY Session
1272
 
SHOW_TABLE_STATUS       DATA_DICTIONARY Table_size
1273
 
SHOW_TABLE_STATUS       DATA_DICTIONARY Type
1274
 
SHOW_TABLE_STATUS       DATA_DICTIONARY Version
1275
 
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY ENGINE
1276
 
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY RECORDS
1277
 
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY RECORD_LENGTH
1278
 
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY TABLE_NAME
1279
 
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY TABLE_SCHEMA
1280
 
TABLES  DATA_DICTIONARY ENGINE
1281
 
TABLES  DATA_DICTIONARY ROW_FORMAT
1282
 
TABLES  DATA_DICTIONARY TABLE_COLLATION
1283
 
TABLES  DATA_DICTIONARY TABLE_COMMENT
1284
 
TABLES  DATA_DICTIONARY TABLE_CREATION_TIME
1285
 
TABLES  DATA_DICTIONARY TABLE_NAME
1286
 
TABLES  DATA_DICTIONARY TABLE_SCHEMA
1287
 
TABLES  DATA_DICTIONARY TABLE_TYPE
1288
 
TABLES  DATA_DICTIONARY TABLE_UPDATE_TIME
1289
 
TABLE_CACHE     DATA_DICTIONARY AUTO_INCREMENT
1290
 
TABLE_CACHE     DATA_DICTIONARY AVG_ROW_LENGTH
1291
 
TABLE_CACHE     DATA_DICTIONARY IS_NAME_LOCKED
1292
 
TABLE_CACHE     DATA_DICTIONARY ROWS
1293
 
TABLE_CACHE     DATA_DICTIONARY SESSION_ID
1294
 
TABLE_CACHE     DATA_DICTIONARY TABLE_NAME
1295
 
TABLE_CACHE     DATA_DICTIONARY TABLE_SCHEMA
1296
 
TABLE_CACHE     DATA_DICTIONARY TABLE_SIZE
1297
 
TABLE_CACHE     DATA_DICTIONARY VERSION
1298
 
TABLE_CONSTRAINTS       DATA_DICTIONARY CONSTRAINT_NAME
1299
 
TABLE_CONSTRAINTS       DATA_DICTIONARY CONSTRAINT_SCHEMA
1300
 
TABLE_CONSTRAINTS       DATA_DICTIONARY CONSTRAINT_TYPE
1301
 
TABLE_CONSTRAINTS       DATA_DICTIONARY TABLE_NAME
1302
 
TABLE_CONSTRAINTS       DATA_DICTIONARY TABLE_SCHEMA
1303
 
TABLE_DEFINITION_CACHE  DATA_DICTIONARY IS_NAME_LOCKED
1304
 
TABLE_DEFINITION_CACHE  DATA_DICTIONARY TABLE_COUNT
1305
 
TABLE_DEFINITION_CACHE  DATA_DICTIONARY TABLE_NAME
1306
 
TABLE_DEFINITION_CACHE  DATA_DICTIONARY TABLE_SCHEMA
1307
 
TABLE_DEFINITION_CACHE  DATA_DICTIONARY VERSION
1308
 
CHECK_CONSTRAINTS       INFORMATION_SCHEMA      CHECK_CLAUSE
1309
 
CHECK_CONSTRAINTS       INFORMATION_SCHEMA      CONSTRAINT_CATALOG
1310
 
CHECK_CONSTRAINTS       INFORMATION_SCHEMA      CONSTRAINT_NAME
1311
 
CHECK_CONSTRAINTS       INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
1312
 
COLUMNS INFORMATION_SCHEMA      CHARACTER_MAXIMUM_LENGTH
1313
 
COLUMNS INFORMATION_SCHEMA      CHARACTER_OCTET_LENGTH
1314
 
COLUMNS INFORMATION_SCHEMA      CHARACTER_SET_CATALOG
1315
 
COLUMNS INFORMATION_SCHEMA      CHARACTER_SET_NAME
1316
 
COLUMNS INFORMATION_SCHEMA      CHARACTER_SET_SCHEMA
1317
 
COLUMNS INFORMATION_SCHEMA      COLLATION_CATALOG
1318
 
COLUMNS INFORMATION_SCHEMA      COLLATION_NAME
1319
 
COLUMNS INFORMATION_SCHEMA      COLLATION_SCHEMA
1320
 
COLUMNS INFORMATION_SCHEMA      COLUMN_DEFAULT
1321
 
COLUMNS INFORMATION_SCHEMA      COLUMN_NAME
1322
 
COLUMNS INFORMATION_SCHEMA      DATA_TYPE
1323
 
COLUMNS INFORMATION_SCHEMA      DATETIME_PRECISION
1324
 
COLUMNS INFORMATION_SCHEMA      DOMAIN_CATALOG
1325
 
COLUMNS INFORMATION_SCHEMA      DOMAIN_NAME
1326
 
COLUMNS INFORMATION_SCHEMA      DOMAIN_SCHEMA
1327
 
COLUMNS INFORMATION_SCHEMA      IS_NULLABLE
1328
 
COLUMNS INFORMATION_SCHEMA      NUMERIC_PRECISION
1329
 
COLUMNS INFORMATION_SCHEMA      NUMERIC_PRECISION_RADIX
1330
 
COLUMNS INFORMATION_SCHEMA      NUMERIC_SCALE
1331
 
COLUMNS INFORMATION_SCHEMA      ORDINAL_POSITION
1332
 
COLUMNS INFORMATION_SCHEMA      TABLE_CATALOG
1333
 
COLUMNS INFORMATION_SCHEMA      TABLE_NAME
1334
 
COLUMNS INFORMATION_SCHEMA      TABLE_SCHEMA
1335
 
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      COLUMN_NAME
1336
 
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      DOMAIN_CATALOG
1337
 
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      DOMAIN_NAME
1338
 
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      DOMAIN_SCHEMA
1339
 
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      TABLE_CATALOG
1340
 
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      TABLE_NAME
1341
 
COLUMN_DOMAIN_USAGE     INFORMATION_SCHEMA      TABLE_SCHEMA
1342
 
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      COLUMN_NAME
1343
 
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      GRANTEE
1344
 
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      GRANTOR
1345
 
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      IS_GRANTABLE
1346
 
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      PRIVILEGE_TYPE
1347
 
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      TABLE_CATALOG
1348
 
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      TABLE_NAME
1349
 
COLUMN_PRIVILEGES       INFORMATION_SCHEMA      TABLE_SCHEMA
1350
 
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      COLUMN_NAME
1351
 
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      CONSTRAINT_CATALOG
1352
 
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      CONSTRAINT_NAME
1353
 
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
1354
 
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      TABLE_CATALOG
1355
 
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      TABLE_NAME
1356
 
CONSTRAINT_COLUMN_USAGE INFORMATION_SCHEMA      TABLE_SCHEMA
1357
 
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      CONSTRAINT_CATALOG
1358
 
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      CONSTRAINT_NAME
1359
 
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
1360
 
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_CATALOG
1361
 
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_NAME
1362
 
CONSTRAINT_TABLE_USAGE  INFORMATION_SCHEMA      TABLE_SCHEMA
1363
 
DOMAINS INFORMATION_SCHEMA      CHARACTER_MAXIMUM_LENGTH
1364
 
DOMAINS INFORMATION_SCHEMA      CHARACTER_OCTET_LENGTH
1365
 
DOMAINS INFORMATION_SCHEMA      CHARACTER_SET_CATALOG
1366
 
DOMAINS INFORMATION_SCHEMA      CHARACTER_SET_NAME
1367
 
DOMAINS INFORMATION_SCHEMA      CHARACTER_SET_SCHEMA
1368
 
DOMAINS INFORMATION_SCHEMA      COLLATION_CATALOG
1369
 
DOMAINS INFORMATION_SCHEMA      COLLATION_NAME
1370
 
DOMAINS INFORMATION_SCHEMA      COLLATION_SCHEMA
1371
 
DOMAINS INFORMATION_SCHEMA      DATA_TYPE
1372
 
DOMAINS INFORMATION_SCHEMA      DATETIME_PRECISION
1373
 
DOMAINS INFORMATION_SCHEMA      DOMAIN_CATALOG
1374
 
DOMAINS INFORMATION_SCHEMA      DOMAIN_DEFAULT
1375
 
DOMAINS INFORMATION_SCHEMA      DOMAIN_NAME
1376
 
DOMAINS INFORMATION_SCHEMA      DOMAIN_SCHEMA
1377
 
DOMAINS INFORMATION_SCHEMA      NUMERIC_PRECISION
1378
 
DOMAINS INFORMATION_SCHEMA      NUMERIC_PRECISION_RADIX
1379
 
DOMAINS INFORMATION_SCHEMA      NUMERIC_SCALE
1380
 
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      CONSTRAINT_CATALOG
1381
 
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      CONSTRAINT_NAME
1382
 
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
1383
 
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      DOMAIN_CATALOG
1384
 
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      DOMAIN_NAME
1385
 
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      DOMAIN_SCHEMA
1386
 
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      INITIALLY_DEFERRED
1387
 
DOMAIN_CONSTRAINTS      INFORMATION_SCHEMA      IS_DEFERRABLE
1388
1291
KEY_COLUMN_USAGE        INFORMATION_SCHEMA      COLUMN_NAME
1389
1292
KEY_COLUMN_USAGE        INFORMATION_SCHEMA      CONSTRAINT_CATALOG
1390
1293
KEY_COLUMN_USAGE        INFORMATION_SCHEMA      CONSTRAINT_NAME
1393
1296
KEY_COLUMN_USAGE        INFORMATION_SCHEMA      TABLE_CATALOG
1394
1297
KEY_COLUMN_USAGE        INFORMATION_SCHEMA      TABLE_NAME
1395
1298
KEY_COLUMN_USAGE        INFORMATION_SCHEMA      TABLE_SCHEMA
 
1299
MODULES DATA_DICTIONARY IS_BUILTIN
 
1300
MODULES DATA_DICTIONARY MODULE_AUTHOR
 
1301
MODULES DATA_DICTIONARY MODULE_DESCRIPTION
 
1302
MODULES DATA_DICTIONARY MODULE_LIBRARY
 
1303
MODULES DATA_DICTIONARY MODULE_LICENSE
 
1304
MODULES DATA_DICTIONARY MODULE_NAME
 
1305
MODULES DATA_DICTIONARY MODULE_VERSION
1396
1306
PARAMETERS      INFORMATION_SCHEMA      AS_LOCATOR
1397
1307
PARAMETERS      INFORMATION_SCHEMA      CHARACTER_MAXIMUM_LENGTH
1398
1308
PARAMETERS      INFORMATION_SCHEMA      CHARACTER_OCTET_LENGTH
1423
1333
PARAMETERS      INFORMATION_SCHEMA      USER_DEFINED_TYPE_CATALOG
1424
1334
PARAMETERS      INFORMATION_SCHEMA      USER_DEFINED_TYPE_NAME
1425
1335
PARAMETERS      INFORMATION_SCHEMA      USER_DEFINED_TYPE_SCHEMA
 
1336
PLUGINS DATA_DICTIONARY IS_ACTIVE
 
1337
PLUGINS DATA_DICTIONARY MODULE_NAME
 
1338
PLUGINS DATA_DICTIONARY PLUGIN_NAME
 
1339
PLUGINS DATA_DICTIONARY PLUGIN_TYPE
 
1340
PROCESSLIST     DATA_DICTIONARY COMMAND
 
1341
PROCESSLIST     DATA_DICTIONARY DB
 
1342
PROCESSLIST     DATA_DICTIONARY HOST
 
1343
PROCESSLIST     DATA_DICTIONARY ID
 
1344
PROCESSLIST     DATA_DICTIONARY INFO
 
1345
PROCESSLIST     DATA_DICTIONARY STATE
 
1346
PROCESSLIST     DATA_DICTIONARY TIME
 
1347
PROCESSLIST     DATA_DICTIONARY USER
 
1348
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_NAME
 
1349
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY CONSTRAINT_SCHEMA
 
1350
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY DELETE_RULE
 
1351
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY MATCH_OPTION
 
1352
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY REFERENCED_TABLE_NAME
 
1353
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY TABLE_NAME
 
1354
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY UNIQUE_CONSTRAINT_NAME
 
1355
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY UNIQUE_CONSTRAINT_SCHEMA
 
1356
REFERENTIAL_CONSTRAINTS DATA_DICTIONARY UPDATE_RULE
1426
1357
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      CONSTRAINT_CATALOG
1427
1358
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      CONSTRAINT_NAME
1428
1359
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
1432
1363
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      UNIQUE_CONSTRAINT_NAME
1433
1364
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      UNIQUE_CONSTRAINT_SCHEMA
1434
1365
REFERENTIAL_CONSTRAINTS INFORMATION_SCHEMA      UPDATE_RULE
 
1366
REPLICATION_STREAMS     DATA_DICTIONARY APPLIER
 
1367
REPLICATION_STREAMS     DATA_DICTIONARY REPLICATOR
1435
1368
ROUTINES        INFORMATION_SCHEMA      CHARACTER_MAXIMUM_LENGTH
1436
1369
ROUTINES        INFORMATION_SCHEMA      CHARACTER_OCTET_LENGTH
1437
1370
ROUTINES        INFORMATION_SCHEMA      CHARACTER_SET_CATALOG
1508
1441
ROUTINE_COLUMNS INFORMATION_SCHEMA      TABLE_CATALOG
1509
1442
ROUTINE_COLUMNS INFORMATION_SCHEMA      TABLE_NAME
1510
1443
ROUTINE_COLUMNS INFORMATION_SCHEMA      TABLE_SCHEMA
 
1444
SCHEMAS DATA_DICTIONARY DEFAULT_COLLATION_NAME
 
1445
SCHEMAS DATA_DICTIONARY SCHEMA_CREATION_TIME
 
1446
SCHEMAS DATA_DICTIONARY SCHEMA_NAME
 
1447
SCHEMAS DATA_DICTIONARY SCHEMA_UPDATE_TIME
1511
1448
SCHEMATA        INFORMATION_SCHEMA      CATALOG_NAME
1512
1449
SCHEMATA        INFORMATION_SCHEMA      DEFAULT_CHARACTER_SET_CATALOG
1513
1450
SCHEMATA        INFORMATION_SCHEMA      DEFAULT_CHARACTER_SET_NAME
1514
1451
SCHEMATA        INFORMATION_SCHEMA      DEFAULT_CHARACTER_SET_SCHEMA
1515
1452
SCHEMATA        INFORMATION_SCHEMA      SCHEMA_NAME
1516
1453
SCHEMATA        INFORMATION_SCHEMA      SCHEMA_OWNER
 
1454
SESSION_STATEMENTS      DATA_DICTIONARY VARIABLE_NAME
 
1455
SESSION_STATEMENTS      DATA_DICTIONARY VARIABLE_VALUE
 
1456
SESSION_STATUS  DATA_DICTIONARY VARIABLE_NAME
 
1457
SESSION_STATUS  DATA_DICTIONARY VARIABLE_VALUE
 
1458
SESSION_VARIABLES       DATA_DICTIONARY VARIABLE_NAME
 
1459
SESSION_VARIABLES       DATA_DICTIONARY VARIABLE_VALUE
 
1460
SHOW_COLUMNS    DATA_DICTIONARY Default
 
1461
SHOW_COLUMNS    DATA_DICTIONARY Default_is_NULL
 
1462
SHOW_COLUMNS    DATA_DICTIONARY Field
 
1463
SHOW_COLUMNS    DATA_DICTIONARY Null
 
1464
SHOW_COLUMNS    DATA_DICTIONARY On_Update
 
1465
SHOW_COLUMNS    DATA_DICTIONARY Type
 
1466
SHOW_INDEXES    DATA_DICTIONARY Column_name
 
1467
SHOW_INDEXES    DATA_DICTIONARY Key_name
 
1468
SHOW_INDEXES    DATA_DICTIONARY Seq_in_index
 
1469
SHOW_INDEXES    DATA_DICTIONARY Table
 
1470
SHOW_INDEXES    DATA_DICTIONARY Unique
 
1471
SHOW_SCHEMAS    DATA_DICTIONARY SCHEMA_NAME
 
1472
SHOW_TABLES     DATA_DICTIONARY TABLE_NAME
 
1473
SHOW_TABLE_STATUS       DATA_DICTIONARY Auto_increment
 
1474
SHOW_TABLE_STATUS       DATA_DICTIONARY Avg_row_length
 
1475
SHOW_TABLE_STATUS       DATA_DICTIONARY Engine
 
1476
SHOW_TABLE_STATUS       DATA_DICTIONARY Name
 
1477
SHOW_TABLE_STATUS       DATA_DICTIONARY Rows
 
1478
SHOW_TABLE_STATUS       DATA_DICTIONARY Schema
 
1479
SHOW_TABLE_STATUS       DATA_DICTIONARY Session
 
1480
SHOW_TABLE_STATUS       DATA_DICTIONARY Table_size
 
1481
SHOW_TABLE_STATUS       DATA_DICTIONARY Type
 
1482
SHOW_TABLE_STATUS       DATA_DICTIONARY Version
 
1483
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY ENGINE
 
1484
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY RECORDS
 
1485
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY RECORD_LENGTH
 
1486
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY TABLE_NAME
 
1487
SHOW_TEMPORARY_TABLES   DATA_DICTIONARY TABLE_SCHEMA
 
1488
TABLES  DATA_DICTIONARY ENGINE
 
1489
TABLES  DATA_DICTIONARY ROW_FORMAT
 
1490
TABLES  DATA_DICTIONARY TABLE_COLLATION
 
1491
TABLES  DATA_DICTIONARY TABLE_COMMENT
 
1492
TABLES  DATA_DICTIONARY TABLE_CREATION_TIME
 
1493
TABLES  DATA_DICTIONARY TABLE_NAME
 
1494
TABLES  DATA_DICTIONARY TABLE_SCHEMA
 
1495
TABLES  DATA_DICTIONARY TABLE_TYPE
 
1496
TABLES  DATA_DICTIONARY TABLE_UPDATE_TIME
1517
1497
TABLES  INFORMATION_SCHEMA      TABLE_CATALOG
1518
1498
TABLES  INFORMATION_SCHEMA      TABLE_NAME
1519
1499
TABLES  INFORMATION_SCHEMA      TABLE_SCHEMA
1520
1500
TABLES  INFORMATION_SCHEMA      TABLE_TYPE
 
1501
TABLE_CACHE     DATA_DICTIONARY AUTO_INCREMENT
 
1502
TABLE_CACHE     DATA_DICTIONARY AVG_ROW_LENGTH
 
1503
TABLE_CACHE     DATA_DICTIONARY IS_NAME_LOCKED
 
1504
TABLE_CACHE     DATA_DICTIONARY ROWS
 
1505
TABLE_CACHE     DATA_DICTIONARY SESSION_ID
 
1506
TABLE_CACHE     DATA_DICTIONARY TABLE_NAME
 
1507
TABLE_CACHE     DATA_DICTIONARY TABLE_SCHEMA
 
1508
TABLE_CACHE     DATA_DICTIONARY TABLE_SIZE
 
1509
TABLE_CACHE     DATA_DICTIONARY VERSION
 
1510
TABLE_CONSTRAINTS       DATA_DICTIONARY CONSTRAINT_NAME
 
1511
TABLE_CONSTRAINTS       DATA_DICTIONARY CONSTRAINT_SCHEMA
 
1512
TABLE_CONSTRAINTS       DATA_DICTIONARY CONSTRAINT_TYPE
 
1513
TABLE_CONSTRAINTS       DATA_DICTIONARY TABLE_NAME
 
1514
TABLE_CONSTRAINTS       DATA_DICTIONARY TABLE_SCHEMA
1521
1515
TABLE_CONSTRAINTS       INFORMATION_SCHEMA      CONSTRAINT_CATALOG
1522
1516
TABLE_CONSTRAINTS       INFORMATION_SCHEMA      CONSTRAINT_NAME
1523
1517
TABLE_CONSTRAINTS       INFORMATION_SCHEMA      CONSTRAINT_SCHEMA
1527
1521
TABLE_CONSTRAINTS       INFORMATION_SCHEMA      TABLE_CATALOG
1528
1522
TABLE_CONSTRAINTS       INFORMATION_SCHEMA      TABLE_NAME
1529
1523
TABLE_CONSTRAINTS       INFORMATION_SCHEMA      TABLE_SCHEMA
 
1524
TABLE_DEFINITION_CACHE  DATA_DICTIONARY IS_NAME_LOCKED
 
1525
TABLE_DEFINITION_CACHE  DATA_DICTIONARY TABLE_COUNT
 
1526
TABLE_DEFINITION_CACHE  DATA_DICTIONARY TABLE_NAME
 
1527
TABLE_DEFINITION_CACHE  DATA_DICTIONARY TABLE_SCHEMA
 
1528
TABLE_DEFINITION_CACHE  DATA_DICTIONARY VERSION
1530
1529
TABLE_PRIVILEGES        INFORMATION_SCHEMA      COLUMN_NAME
1531
1530
TABLE_PRIVILEGES        INFORMATION_SCHEMA      GRANTEE
1532
1531
TABLE_PRIVILEGES        INFORMATION_SCHEMA      GRANTOR
1554
1553
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_NAME
1555
1554
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_SCHEMA
1556
1555
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      VIEW_DEFINITION
 
1556
a       a       a
1557
1557
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_NAME,TABLE_SCHEMA, COLUMN_NAME;
1558
1558
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
1559
 
a       a       a
1560
1559
CHARACTER_SETS  DATA_DICTIONARY CHARACTER_SET_NAME
1561
1560
CHARACTER_SETS  DATA_DICTIONARY DEFAULT_COLLATE_NAME
1562
1561
CHARACTER_SETS  DATA_DICTIONARY DESCRIPTION
2031
2030
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_NAME
2032
2031
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_SCHEMA
2033
2032
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      VIEW_DEFINITION
 
2033
a       a       a
2034
2034
DROP SCHEMA A;