~drizzle-trunk/drizzle/development
» Revision
1861.4.3
: plugin/information_schema_dictionary/tests/r/tables.result
« back to all changes in this revision
Viewing changes to plugin/information_schema_dictionary/tests/r/tables.result
- browse files at revision 1861.4.3
- compare with another revision
- download diff
- download tarball
- view history from revision 1861.4.3
- Committer: Brian Aker
- Date: 2010-10-20 05:59:29 UTC
- mfrom: (1861.5.2 catalogs)
- mto: (1859.2.12 refactor)
- mto: This revision was merged to the branch mainline in revision 1864.
- Revision ID: brian@tangent.org-20101020055929-e4xx3dcm2mqiul3h
Merge in change for catalog to be displayed properly
- files added:
- drizzled/generator/session.h
- files modified:
- drizzled/identifier/schema.cc
added
removed
plugin/information_schema_dictionary/tests/r/tables.result
6
6
test
7
7
select * from INFORMATION_SCHEMA.TABLES;
8
8
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
9
DATA_DICTIONARY CHARACTER_SETS VIEW
10
DATA_DICTIONARY COLLATIONS VIEW
11
DATA_DICTIONARY COLUMNS VIEW
12
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
13
DATA_DICTIONARY CUMULATIVE_USER_STATS VIEW
14
DATA_DICTIONARY CURRENT_SQL_COMMANDS VIEW
15
DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS VIEW
16
DATA_DICTIONARY FOREIGN_KEYS VIEW
17
DATA_DICTIONARY GLOBAL_STATEMENTS VIEW
18
DATA_DICTIONARY GLOBAL_STATUS VIEW
19
DATA_DICTIONARY GLOBAL_VARIABLES VIEW
20
DATA_DICTIONARY INDEXES VIEW
21
DATA_DICTIONARY INDEX_PARTS VIEW
22
DATA_DICTIONARY INNODB_CMP VIEW
23
DATA_DICTIONARY INNODB_CMPMEM VIEW
24
DATA_DICTIONARY INNODB_CMPMEM_RESET VIEW
25
DATA_DICTIONARY INNODB_CMP_RESET VIEW
26
DATA_DICTIONARY INNODB_INTERNAL_TABLES VIEW
27
DATA_DICTIONARY INNODB_LOCKS VIEW
28
DATA_DICTIONARY INNODB_LOCK_WAITS VIEW
29
DATA_DICTIONARY INNODB_STATUS VIEW
30
DATA_DICTIONARY INNODB_TRX VIEW
31
DATA_DICTIONARY MODULES VIEW
32
DATA_DICTIONARY MYSQL_PROTOCOL_STATUS VIEW
33
DATA_DICTIONARY PLUGINS VIEW
34
DATA_DICTIONARY PROCESSLIST VIEW
35
DATA_DICTIONARY REPLICATION_STREAMS VIEW
36
DATA_DICTIONARY SCHEMAS VIEW
37
DATA_DICTIONARY SCHEMA_SQL_DEFINITION VIEW
38
DATA_DICTIONARY SCOREBOARD_STATISTICS VIEW
39
DATA_DICTIONARY SESSION_STATEMENTS VIEW
40
DATA_DICTIONARY SESSION_STATUS VIEW
41
DATA_DICTIONARY SESSION_VARIABLES VIEW
42
DATA_DICTIONARY SHOW_COLUMNS VIEW
43
DATA_DICTIONARY SHOW_INDEXES VIEW
44
DATA_DICTIONARY SHOW_SCHEMAS VIEW
45
DATA_DICTIONARY SHOW_TABLES VIEW
46
DATA_DICTIONARY SHOW_TABLE_STATUS VIEW
47
DATA_DICTIONARY SHOW_TEMPORARY_TABLES VIEW
48
DATA_DICTIONARY TABLES VIEW
49
DATA_DICTIONARY TABLE_CACHE VIEW
50
DATA_DICTIONARY TABLE_CONSTRAINTS VIEW
51
DATA_DICTIONARY TABLE_DEFINITION_CACHE VIEW
52
DATA_DICTIONARY TABLE_SQL_DEFINITION VIEW
53
DATA_DICTIONARY USER_LOCKS VIEW
54
INFORMATION_SCHEMA CHECK_CONSTRAINTS VIEW
55
INFORMATION_SCHEMA COLUMNS VIEW
56
INFORMATION_SCHEMA COLUMN_DOMAIN_USAGE VIEW
57
INFORMATION_SCHEMA COLUMN_PRIVILEGES VIEW
58
INFORMATION_SCHEMA CONSTRAINT_COLUMN_USAGE VIEW
59
INFORMATION_SCHEMA CONSTRAINT_TABLE_USAGE VIEW
60
INFORMATION_SCHEMA DOMAINS VIEW
61
INFORMATION_SCHEMA DOMAIN_CONSTRAINTS VIEW
62
INFORMATION_SCHEMA KEY_COLUMN_USAGE VIEW
63
INFORMATION_SCHEMA PARAMETERS VIEW
64
INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS VIEW
65
INFORMATION_SCHEMA ROUTINES VIEW
66
INFORMATION_SCHEMA ROUTINE_COLUMNS VIEW
67
INFORMATION_SCHEMA SCHEMATA VIEW
68
INFORMATION_SCHEMA TABLES VIEW
69
INFORMATION_SCHEMA TABLE_CONSTRAINTS VIEW
70
INFORMATION_SCHEMA TABLE_PRIVILEGES VIEW
71
INFORMATION_SCHEMA VIEWS VIEW
72
INFORMATION_SCHEMA VIEW_COLUMN_USAGE VIEW
73
INFORMATION_SCHEMA VIEW_TABLE_USAGE VIEW
9
LOCAL DATA_DICTIONARY CHARACTER_SETS VIEW
10
LOCAL DATA_DICTIONARY COLLATIONS VIEW
11
LOCAL DATA_DICTIONARY COLUMNS VIEW
12
LOCAL DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
13
LOCAL DATA_DICTIONARY CUMULATIVE_USER_STATS VIEW
14
LOCAL DATA_DICTIONARY CURRENT_SQL_COMMANDS VIEW
15
LOCAL DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS VIEW
16
LOCAL DATA_DICTIONARY FOREIGN_KEYS VIEW
17
LOCAL DATA_DICTIONARY GLOBAL_STATEMENTS VIEW
18
LOCAL DATA_DICTIONARY GLOBAL_STATUS VIEW
19
LOCAL DATA_DICTIONARY GLOBAL_VARIABLES VIEW
20
LOCAL DATA_DICTIONARY INDEXES VIEW
21
LOCAL DATA_DICTIONARY INDEX_PARTS VIEW
22
LOCAL DATA_DICTIONARY INNODB_CMP VIEW
23
LOCAL DATA_DICTIONARY INNODB_CMPMEM VIEW
24
LOCAL DATA_DICTIONARY INNODB_CMPMEM_RESET VIEW
25
LOCAL DATA_DICTIONARY INNODB_CMP_RESET VIEW
26
LOCAL DATA_DICTIONARY INNODB_INTERNAL_TABLES VIEW
27
LOCAL DATA_DICTIONARY INNODB_LOCKS VIEW
28
LOCAL DATA_DICTIONARY INNODB_LOCK_WAITS VIEW
29
LOCAL DATA_DICTIONARY INNODB_STATUS VIEW
30
LOCAL DATA_DICTIONARY INNODB_TRX VIEW
31
LOCAL DATA_DICTIONARY MODULES VIEW
32
LOCAL DATA_DICTIONARY MYSQL_PROTOCOL_STATUS VIEW
33
LOCAL DATA_DICTIONARY PLUGINS VIEW
34
LOCAL DATA_DICTIONARY PROCESSLIST VIEW
35
LOCAL DATA_DICTIONARY REPLICATION_STREAMS VIEW
36
LOCAL DATA_DICTIONARY SCHEMAS VIEW
37
LOCAL DATA_DICTIONARY SCHEMA_SQL_DEFINITION VIEW
38
LOCAL DATA_DICTIONARY SCOREBOARD_STATISTICS VIEW
39
LOCAL DATA_DICTIONARY SESSION_STATEMENTS VIEW
40
LOCAL DATA_DICTIONARY SESSION_STATUS VIEW
41
LOCAL DATA_DICTIONARY SESSION_VARIABLES VIEW
42
LOCAL DATA_DICTIONARY SHOW_COLUMNS VIEW
43
LOCAL DATA_DICTIONARY SHOW_INDEXES VIEW
44
LOCAL DATA_DICTIONARY SHOW_SCHEMAS VIEW
45
LOCAL DATA_DICTIONARY SHOW_TABLES VIEW
46
LOCAL DATA_DICTIONARY SHOW_TABLE_STATUS VIEW
47
LOCAL DATA_DICTIONARY SHOW_TEMPORARY_TABLES VIEW
48
LOCAL DATA_DICTIONARY TABLES VIEW
49
LOCAL DATA_DICTIONARY TABLE_CACHE VIEW
50
LOCAL DATA_DICTIONARY TABLE_CONSTRAINTS VIEW
51
LOCAL DATA_DICTIONARY TABLE_DEFINITION_CACHE VIEW
52
LOCAL DATA_DICTIONARY TABLE_SQL_DEFINITION VIEW
53
LOCAL DATA_DICTIONARY USER_LOCKS VIEW
54
LOCAL INFORMATION_SCHEMA CHECK_CONSTRAINTS VIEW
55
LOCAL INFORMATION_SCHEMA COLUMNS VIEW
56
LOCAL INFORMATION_SCHEMA COLUMN_DOMAIN_USAGE VIEW
57
LOCAL INFORMATION_SCHEMA COLUMN_PRIVILEGES VIEW
58
LOCAL INFORMATION_SCHEMA CONSTRAINT_COLUMN_USAGE VIEW
59
LOCAL INFORMATION_SCHEMA CONSTRAINT_TABLE_USAGE VIEW
60
LOCAL INFORMATION_SCHEMA DOMAINS VIEW
61
LOCAL INFORMATION_SCHEMA DOMAIN_CONSTRAINTS VIEW
62
LOCAL INFORMATION_SCHEMA KEY_COLUMN_USAGE VIEW
63
LOCAL INFORMATION_SCHEMA PARAMETERS VIEW
64
LOCAL INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS VIEW
65
LOCAL INFORMATION_SCHEMA ROUTINES VIEW
66
LOCAL INFORMATION_SCHEMA ROUTINE_COLUMNS VIEW
67
LOCAL INFORMATION_SCHEMA SCHEMATA VIEW
68
LOCAL INFORMATION_SCHEMA TABLES VIEW
69
LOCAL INFORMATION_SCHEMA TABLE_CONSTRAINTS VIEW
70
LOCAL INFORMATION_SCHEMA TABLE_PRIVILEGES VIEW
71
LOCAL INFORMATION_SCHEMA VIEWS VIEW
72
LOCAL INFORMATION_SCHEMA VIEW_COLUMN_USAGE VIEW
73
LOCAL INFORMATION_SCHEMA VIEW_TABLE_USAGE VIEW
74
74
use information_schema;
75
75
show schemas;
76
76
Database
80
80
test
81
81
select * from INFORMATION_SCHEMA.TABLES;
82
82
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
83
DATA_DICTIONARY CHARACTER_SETS VIEW
84
DATA_DICTIONARY COLLATIONS VIEW
85
DATA_DICTIONARY COLUMNS VIEW
86
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
87
DATA_DICTIONARY CUMULATIVE_USER_STATS VIEW
88
DATA_DICTIONARY CURRENT_SQL_COMMANDS VIEW
89
DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS VIEW
90
DATA_DICTIONARY FOREIGN_KEYS VIEW
91
DATA_DICTIONARY GLOBAL_STATEMENTS VIEW
92
DATA_DICTIONARY GLOBAL_STATUS VIEW
93
DATA_DICTIONARY GLOBAL_VARIABLES VIEW
94
DATA_DICTIONARY INDEXES VIEW
95
DATA_DICTIONARY INDEX_PARTS VIEW
96
DATA_DICTIONARY INNODB_CMP VIEW
97
DATA_DICTIONARY INNODB_CMPMEM VIEW
98
DATA_DICTIONARY INNODB_CMPMEM_RESET VIEW
99
DATA_DICTIONARY INNODB_CMP_RESET VIEW
100
DATA_DICTIONARY INNODB_INTERNAL_TABLES VIEW
101
DATA_DICTIONARY INNODB_LOCKS VIEW
102
DATA_DICTIONARY INNODB_LOCK_WAITS VIEW
103
DATA_DICTIONARY INNODB_STATUS VIEW
104
DATA_DICTIONARY INNODB_TRX VIEW
105
DATA_DICTIONARY MODULES VIEW
106
DATA_DICTIONARY MYSQL_PROTOCOL_STATUS VIEW
107
DATA_DICTIONARY PLUGINS VIEW
108
DATA_DICTIONARY PROCESSLIST VIEW
109
DATA_DICTIONARY REPLICATION_STREAMS VIEW
110
DATA_DICTIONARY SCHEMAS VIEW
111
DATA_DICTIONARY SCHEMA_SQL_DEFINITION VIEW
112
DATA_DICTIONARY SCOREBOARD_STATISTICS VIEW
113
DATA_DICTIONARY SESSION_STATEMENTS VIEW
114
DATA_DICTIONARY SESSION_STATUS VIEW
115
DATA_DICTIONARY SESSION_VARIABLES VIEW
116
DATA_DICTIONARY SHOW_COLUMNS VIEW
117
DATA_DICTIONARY SHOW_INDEXES VIEW
118
DATA_DICTIONARY SHOW_SCHEMAS VIEW
119
DATA_DICTIONARY SHOW_TABLES VIEW
120
DATA_DICTIONARY SHOW_TABLE_STATUS VIEW
121
DATA_DICTIONARY SHOW_TEMPORARY_TABLES VIEW
122
DATA_DICTIONARY TABLES VIEW
123
DATA_DICTIONARY TABLE_CACHE VIEW
124
DATA_DICTIONARY TABLE_CONSTRAINTS VIEW
125
DATA_DICTIONARY TABLE_DEFINITION_CACHE VIEW
126
DATA_DICTIONARY TABLE_SQL_DEFINITION VIEW
127
DATA_DICTIONARY USER_LOCKS VIEW
128
INFORMATION_SCHEMA CHECK_CONSTRAINTS VIEW
129
INFORMATION_SCHEMA COLUMNS VIEW
130
INFORMATION_SCHEMA COLUMN_DOMAIN_USAGE VIEW
131
INFORMATION_SCHEMA COLUMN_PRIVILEGES VIEW
132
INFORMATION_SCHEMA CONSTRAINT_COLUMN_USAGE VIEW
133
INFORMATION_SCHEMA CONSTRAINT_TABLE_USAGE VIEW
134
INFORMATION_SCHEMA DOMAINS VIEW
135
INFORMATION_SCHEMA DOMAIN_CONSTRAINTS VIEW
136
INFORMATION_SCHEMA KEY_COLUMN_USAGE VIEW
137
INFORMATION_SCHEMA PARAMETERS VIEW
138
INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS VIEW
139
INFORMATION_SCHEMA ROUTINES VIEW
140
INFORMATION_SCHEMA ROUTINE_COLUMNS VIEW
141
INFORMATION_SCHEMA SCHEMATA VIEW
142
INFORMATION_SCHEMA TABLES VIEW
143
INFORMATION_SCHEMA TABLE_CONSTRAINTS VIEW
144
INFORMATION_SCHEMA TABLE_PRIVILEGES VIEW
145
INFORMATION_SCHEMA VIEWS VIEW
146
INFORMATION_SCHEMA VIEW_COLUMN_USAGE VIEW
147
INFORMATION_SCHEMA VIEW_TABLE_USAGE VIEW
83
LOCAL DATA_DICTIONARY CHARACTER_SETS VIEW
84
LOCAL DATA_DICTIONARY COLLATIONS VIEW
85
LOCAL DATA_DICTIONARY COLUMNS VIEW
86
LOCAL DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
87
LOCAL DATA_DICTIONARY CUMULATIVE_USER_STATS VIEW
88
LOCAL DATA_DICTIONARY CURRENT_SQL_COMMANDS VIEW
89
LOCAL DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS VIEW
90
LOCAL DATA_DICTIONARY FOREIGN_KEYS VIEW
91
LOCAL DATA_DICTIONARY GLOBAL_STATEMENTS VIEW
92
LOCAL DATA_DICTIONARY GLOBAL_STATUS VIEW
93
LOCAL DATA_DICTIONARY GLOBAL_VARIABLES VIEW
94
LOCAL DATA_DICTIONARY INDEXES VIEW
95
LOCAL DATA_DICTIONARY INDEX_PARTS VIEW
96
LOCAL DATA_DICTIONARY INNODB_CMP VIEW
97
LOCAL DATA_DICTIONARY INNODB_CMPMEM VIEW
98
LOCAL DATA_DICTIONARY INNODB_CMPMEM_RESET VIEW
99
LOCAL DATA_DICTIONARY INNODB_CMP_RESET VIEW
100
LOCAL DATA_DICTIONARY INNODB_INTERNAL_TABLES VIEW
101
LOCAL DATA_DICTIONARY INNODB_LOCKS VIEW
102
LOCAL DATA_DICTIONARY INNODB_LOCK_WAITS VIEW
103
LOCAL DATA_DICTIONARY INNODB_STATUS VIEW
104
LOCAL DATA_DICTIONARY INNODB_TRX VIEW
105
LOCAL DATA_DICTIONARY MODULES VIEW
106
LOCAL DATA_DICTIONARY MYSQL_PROTOCOL_STATUS VIEW
107
LOCAL DATA_DICTIONARY PLUGINS VIEW
108
LOCAL DATA_DICTIONARY PROCESSLIST VIEW
109
LOCAL DATA_DICTIONARY REPLICATION_STREAMS VIEW
110
LOCAL DATA_DICTIONARY SCHEMAS VIEW
111
LOCAL DATA_DICTIONARY SCHEMA_SQL_DEFINITION VIEW
112
LOCAL DATA_DICTIONARY SCOREBOARD_STATISTICS VIEW
113
LOCAL DATA_DICTIONARY SESSION_STATEMENTS VIEW
114
LOCAL DATA_DICTIONARY SESSION_STATUS VIEW
115
LOCAL DATA_DICTIONARY SESSION_VARIABLES VIEW
116
LOCAL DATA_DICTIONARY SHOW_COLUMNS VIEW
117
LOCAL DATA_DICTIONARY SHOW_INDEXES VIEW
118
LOCAL DATA_DICTIONARY SHOW_SCHEMAS VIEW
119
LOCAL DATA_DICTIONARY SHOW_TABLES VIEW
120
LOCAL DATA_DICTIONARY SHOW_TABLE_STATUS VIEW
121
LOCAL DATA_DICTIONARY SHOW_TEMPORARY_TABLES VIEW
122
LOCAL DATA_DICTIONARY TABLES VIEW
123
LOCAL DATA_DICTIONARY TABLE_CACHE VIEW
124
LOCAL DATA_DICTIONARY TABLE_CONSTRAINTS VIEW
125
LOCAL DATA_DICTIONARY TABLE_DEFINITION_CACHE VIEW
126
LOCAL DATA_DICTIONARY TABLE_SQL_DEFINITION VIEW
127
LOCAL DATA_DICTIONARY USER_LOCKS VIEW
128
LOCAL INFORMATION_SCHEMA CHECK_CONSTRAINTS VIEW
129
LOCAL INFORMATION_SCHEMA COLUMNS VIEW
130
LOCAL INFORMATION_SCHEMA COLUMN_DOMAIN_USAGE VIEW
131
LOCAL INFORMATION_SCHEMA COLUMN_PRIVILEGES VIEW
132
LOCAL INFORMATION_SCHEMA CONSTRAINT_COLUMN_USAGE VIEW
133
LOCAL INFORMATION_SCHEMA CONSTRAINT_TABLE_USAGE VIEW
134
LOCAL INFORMATION_SCHEMA DOMAINS VIEW
135
LOCAL INFORMATION_SCHEMA DOMAIN_CONSTRAINTS VIEW
136
LOCAL INFORMATION_SCHEMA KEY_COLUMN_USAGE VIEW
137
LOCAL INFORMATION_SCHEMA PARAMETERS VIEW
138
LOCAL INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS VIEW
139
LOCAL INFORMATION_SCHEMA ROUTINES VIEW
140
LOCAL INFORMATION_SCHEMA ROUTINE_COLUMNS VIEW
141
LOCAL INFORMATION_SCHEMA SCHEMATA VIEW
142
LOCAL INFORMATION_SCHEMA TABLES VIEW
143
LOCAL INFORMATION_SCHEMA TABLE_CONSTRAINTS VIEW
144
LOCAL INFORMATION_SCHEMA TABLE_PRIVILEGES VIEW
145
LOCAL INFORMATION_SCHEMA VIEWS VIEW
146
LOCAL INFORMATION_SCHEMA VIEW_COLUMN_USAGE VIEW
147
LOCAL INFORMATION_SCHEMA VIEW_TABLE_USAGE VIEW
148
148
select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG=NULL;
149
149
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
150
150
select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=NULL;
155
155
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
156
156
select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="information_schema" AND TABLE_TYPE="VIEW";
157
157
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
158
INFORMATION_SCHEMA CHECK_CONSTRAINTS VIEW
159
INFORMATION_SCHEMA COLUMNS VIEW
160
INFORMATION_SCHEMA COLUMN_DOMAIN_USAGE VIEW
161
INFORMATION_SCHEMA COLUMN_PRIVILEGES VIEW
162
INFORMATION_SCHEMA CONSTRAINT_COLUMN_USAGE VIEW
163
INFORMATION_SCHEMA CONSTRAINT_TABLE_USAGE VIEW
164
INFORMATION_SCHEMA DOMAINS VIEW
165
INFORMATION_SCHEMA DOMAIN_CONSTRAINTS VIEW
166
INFORMATION_SCHEMA KEY_COLUMN_USAGE VIEW
167
INFORMATION_SCHEMA PARAMETERS VIEW
168
INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS VIEW
169
INFORMATION_SCHEMA ROUTINES VIEW
170
INFORMATION_SCHEMA ROUTINE_COLUMNS VIEW
171
INFORMATION_SCHEMA SCHEMATA VIEW
172
INFORMATION_SCHEMA TABLES VIEW
173
INFORMATION_SCHEMA TABLE_CONSTRAINTS VIEW
174
INFORMATION_SCHEMA TABLE_PRIVILEGES VIEW
175
INFORMATION_SCHEMA VIEWS VIEW
176
INFORMATION_SCHEMA VIEW_COLUMN_USAGE VIEW
177
INFORMATION_SCHEMA VIEW_TABLE_USAGE VIEW
158
LOCAL INFORMATION_SCHEMA CHECK_CONSTRAINTS VIEW
159
LOCAL INFORMATION_SCHEMA COLUMNS VIEW
160
LOCAL INFORMATION_SCHEMA COLUMN_DOMAIN_USAGE VIEW
161
LOCAL INFORMATION_SCHEMA COLUMN_PRIVILEGES VIEW
162
LOCAL INFORMATION_SCHEMA CONSTRAINT_COLUMN_USAGE VIEW
163
LOCAL INFORMATION_SCHEMA CONSTRAINT_TABLE_USAGE VIEW
164
LOCAL INFORMATION_SCHEMA DOMAINS VIEW
165
LOCAL INFORMATION_SCHEMA DOMAIN_CONSTRAINTS VIEW
166
LOCAL INFORMATION_SCHEMA KEY_COLUMN_USAGE VIEW
167
LOCAL INFORMATION_SCHEMA PARAMETERS VIEW
168
LOCAL INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS VIEW
169
LOCAL INFORMATION_SCHEMA ROUTINES VIEW
170
LOCAL INFORMATION_SCHEMA ROUTINE_COLUMNS VIEW
171
LOCAL INFORMATION_SCHEMA SCHEMATA VIEW
172
LOCAL INFORMATION_SCHEMA TABLES VIEW
173
LOCAL INFORMATION_SCHEMA TABLE_CONSTRAINTS VIEW
174
LOCAL INFORMATION_SCHEMA TABLE_PRIVILEGES VIEW
175
LOCAL INFORMATION_SCHEMA VIEWS VIEW
176
LOCAL INFORMATION_SCHEMA VIEW_COLUMN_USAGE VIEW
177
LOCAL INFORMATION_SCHEMA VIEW_TABLE_USAGE VIEW
178
178
select * from INFORMATION_SCHEMA.TABLES ORDER BY TABLE_SCHEMA, TABLE_NAME;
179
179
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
180
DATA_DICTIONARY CHARACTER_SETS VIEW
181
DATA_DICTIONARY COLLATIONS VIEW
182
DATA_DICTIONARY COLUMNS VIEW
183
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
184
DATA_DICTIONARY CUMULATIVE_USER_STATS VIEW
185
DATA_DICTIONARY CURRENT_SQL_COMMANDS VIEW
186
DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS VIEW
187
DATA_DICTIONARY FOREIGN_KEYS VIEW
188
DATA_DICTIONARY GLOBAL_STATEMENTS VIEW
189
DATA_DICTIONARY GLOBAL_STATUS VIEW
190
DATA_DICTIONARY GLOBAL_VARIABLES VIEW
191
DATA_DICTIONARY INDEXES VIEW
192
DATA_DICTIONARY INDEX_PARTS VIEW
193
DATA_DICTIONARY INNODB_CMP VIEW
194
DATA_DICTIONARY INNODB_CMPMEM VIEW
195
DATA_DICTIONARY INNODB_CMPMEM_RESET VIEW
196
DATA_DICTIONARY INNODB_CMP_RESET VIEW
197
DATA_DICTIONARY INNODB_INTERNAL_TABLES VIEW
198
DATA_DICTIONARY INNODB_LOCKS VIEW
199
DATA_DICTIONARY INNODB_LOCK_WAITS VIEW
200
DATA_DICTIONARY INNODB_STATUS VIEW
201
DATA_DICTIONARY INNODB_TRX VIEW
202
DATA_DICTIONARY MODULES VIEW
203
DATA_DICTIONARY MYSQL_PROTOCOL_STATUS VIEW
204
DATA_DICTIONARY PLUGINS VIEW
205
DATA_DICTIONARY PROCESSLIST VIEW
206
DATA_DICTIONARY REPLICATION_STREAMS VIEW
207
DATA_DICTIONARY SCHEMAS VIEW
208
DATA_DICTIONARY SCHEMA_SQL_DEFINITION VIEW
209
DATA_DICTIONARY SCOREBOARD_STATISTICS VIEW
210
DATA_DICTIONARY SESSION_STATEMENTS VIEW
211
DATA_DICTIONARY SESSION_STATUS VIEW
212
DATA_DICTIONARY SESSION_VARIABLES VIEW
213
DATA_DICTIONARY SHOW_COLUMNS VIEW
214
DATA_DICTIONARY SHOW_INDEXES VIEW
215
DATA_DICTIONARY SHOW_SCHEMAS VIEW
216
DATA_DICTIONARY SHOW_TABLES VIEW
217
DATA_DICTIONARY SHOW_TABLE_STATUS VIEW
218
DATA_DICTIONARY SHOW_TEMPORARY_TABLES VIEW
219
DATA_DICTIONARY TABLES VIEW
220
DATA_DICTIONARY TABLE_CACHE VIEW
221
DATA_DICTIONARY TABLE_CONSTRAINTS VIEW
222
DATA_DICTIONARY TABLE_DEFINITION_CACHE VIEW
223
DATA_DICTIONARY TABLE_SQL_DEFINITION VIEW
224
DATA_DICTIONARY USER_LOCKS VIEW
225
INFORMATION_SCHEMA CHECK_CONSTRAINTS VIEW
226
INFORMATION_SCHEMA COLUMNS VIEW
227
INFORMATION_SCHEMA COLUMN_DOMAIN_USAGE VIEW
228
INFORMATION_SCHEMA COLUMN_PRIVILEGES VIEW
229
INFORMATION_SCHEMA CONSTRAINT_COLUMN_USAGE VIEW
230
INFORMATION_SCHEMA CONSTRAINT_TABLE_USAGE VIEW
231
INFORMATION_SCHEMA DOMAINS VIEW
232
INFORMATION_SCHEMA DOMAIN_CONSTRAINTS VIEW
233
INFORMATION_SCHEMA KEY_COLUMN_USAGE VIEW
234
INFORMATION_SCHEMA PARAMETERS VIEW
235
INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS VIEW
236
INFORMATION_SCHEMA ROUTINES VIEW
237
INFORMATION_SCHEMA ROUTINE_COLUMNS VIEW
238
INFORMATION_SCHEMA SCHEMATA VIEW
239
INFORMATION_SCHEMA TABLES VIEW
240
INFORMATION_SCHEMA TABLE_CONSTRAINTS VIEW
241
INFORMATION_SCHEMA TABLE_PRIVILEGES VIEW
242
INFORMATION_SCHEMA VIEWS VIEW
243
INFORMATION_SCHEMA VIEW_COLUMN_USAGE VIEW
244
INFORMATION_SCHEMA VIEW_TABLE_USAGE VIEW
180
LOCAL DATA_DICTIONARY CHARACTER_SETS VIEW
181
LOCAL DATA_DICTIONARY COLLATIONS VIEW
182
LOCAL DATA_DICTIONARY COLUMNS VIEW
183
LOCAL DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
184
LOCAL DATA_DICTIONARY CUMULATIVE_USER_STATS VIEW
185
LOCAL DATA_DICTIONARY CURRENT_SQL_COMMANDS VIEW
186
LOCAL DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS VIEW
187
LOCAL DATA_DICTIONARY FOREIGN_KEYS VIEW
188
LOCAL DATA_DICTIONARY GLOBAL_STATEMENTS VIEW
189
LOCAL DATA_DICTIONARY GLOBAL_STATUS VIEW
190
LOCAL DATA_DICTIONARY GLOBAL_VARIABLES VIEW
191
LOCAL DATA_DICTIONARY INDEXES VIEW
192
LOCAL DATA_DICTIONARY INDEX_PARTS VIEW
193
LOCAL DATA_DICTIONARY INNODB_CMP VIEW
194
LOCAL DATA_DICTIONARY INNODB_CMPMEM VIEW
195
LOCAL DATA_DICTIONARY INNODB_CMPMEM_RESET VIEW
196
LOCAL DATA_DICTIONARY INNODB_CMP_RESET VIEW
197
LOCAL DATA_DICTIONARY INNODB_INTERNAL_TABLES VIEW
198
LOCAL DATA_DICTIONARY INNODB_LOCKS VIEW
199
LOCAL DATA_DICTIONARY INNODB_LOCK_WAITS VIEW
200
LOCAL DATA_DICTIONARY INNODB_STATUS VIEW
201
LOCAL DATA_DICTIONARY INNODB_TRX VIEW
202
LOCAL DATA_DICTIONARY MODULES VIEW
203
LOCAL DATA_DICTIONARY MYSQL_PROTOCOL_STATUS VIEW
204
LOCAL DATA_DICTIONARY PLUGINS VIEW
205
LOCAL DATA_DICTIONARY PROCESSLIST VIEW
206
LOCAL DATA_DICTIONARY REPLICATION_STREAMS VIEW
207
LOCAL DATA_DICTIONARY SCHEMAS VIEW
208
LOCAL DATA_DICTIONARY SCHEMA_SQL_DEFINITION VIEW
209
LOCAL DATA_DICTIONARY SCOREBOARD_STATISTICS VIEW
210
LOCAL DATA_DICTIONARY SESSION_STATEMENTS VIEW
211
LOCAL DATA_DICTIONARY SESSION_STATUS VIEW
212
LOCAL DATA_DICTIONARY SESSION_VARIABLES VIEW
213
LOCAL DATA_DICTIONARY SHOW_COLUMNS VIEW
214
LOCAL DATA_DICTIONARY SHOW_INDEXES VIEW
215
LOCAL DATA_DICTIONARY SHOW_SCHEMAS VIEW
216
LOCAL DATA_DICTIONARY SHOW_TABLES VIEW
217
LOCAL DATA_DICTIONARY SHOW_TABLE_STATUS VIEW
218
LOCAL DATA_DICTIONARY SHOW_TEMPORARY_TABLES VIEW
219
LOCAL DATA_DICTIONARY TABLES VIEW
220
LOCAL DATA_DICTIONARY TABLE_CACHE VIEW
221
LOCAL DATA_DICTIONARY TABLE_CONSTRAINTS VIEW
222
LOCAL DATA_DICTIONARY TABLE_DEFINITION_CACHE VIEW
223
LOCAL DATA_DICTIONARY TABLE_SQL_DEFINITION VIEW
224
LOCAL DATA_DICTIONARY USER_LOCKS VIEW
225
LOCAL INFORMATION_SCHEMA CHECK_CONSTRAINTS VIEW
226
LOCAL INFORMATION_SCHEMA COLUMNS VIEW
227
LOCAL INFORMATION_SCHEMA COLUMN_DOMAIN_USAGE VIEW
228
LOCAL INFORMATION_SCHEMA COLUMN_PRIVILEGES VIEW
229
LOCAL INFORMATION_SCHEMA CONSTRAINT_COLUMN_USAGE VIEW
230
LOCAL INFORMATION_SCHEMA CONSTRAINT_TABLE_USAGE VIEW
231
LOCAL INFORMATION_SCHEMA DOMAINS VIEW
232
LOCAL INFORMATION_SCHEMA DOMAIN_CONSTRAINTS VIEW
233
LOCAL INFORMATION_SCHEMA KEY_COLUMN_USAGE VIEW
234
LOCAL INFORMATION_SCHEMA PARAMETERS VIEW
235
LOCAL INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS VIEW
236
LOCAL INFORMATION_SCHEMA ROUTINES VIEW
237
LOCAL INFORMATION_SCHEMA ROUTINE_COLUMNS VIEW
238
LOCAL INFORMATION_SCHEMA SCHEMATA VIEW
239
LOCAL INFORMATION_SCHEMA TABLES VIEW
240
LOCAL INFORMATION_SCHEMA TABLE_CONSTRAINTS VIEW
241
LOCAL INFORMATION_SCHEMA TABLE_PRIVILEGES VIEW
242
LOCAL INFORMATION_SCHEMA VIEWS VIEW
243
LOCAL INFORMATION_SCHEMA VIEW_COLUMN_USAGE VIEW
244
LOCAL INFORMATION_SCHEMA VIEW_TABLE_USAGE VIEW
245
245
create schema a;
246
246
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="a";
247
247
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
262
262
ds
263
263
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME="a";
264
264
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
265
a a BASE
265
LOCAL a a BASE
266
266
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like "a%";
267
267
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
268
a a BASE
269
a aa BASE
268
LOCAL a a BASE
269
LOCAL a aa BASE
270
270
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like "%a";
271
271
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
272
INFORMATION_SCHEMA SCHEMATA VIEW
273
a a BASE
274
a aa BASE
272
LOCAL INFORMATION_SCHEMA SCHEMATA VIEW
273
LOCAL a a BASE
274
LOCAL a aa BASE
275
275
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like "%s";
276
276
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
277
DATA_DICTIONARY CHARACTER_SETS VIEW
278
DATA_DICTIONARY COLLATIONS VIEW
279
DATA_DICTIONARY COLUMNS VIEW
280
DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
281
DATA_DICTIONARY CUMULATIVE_USER_STATS VIEW
282
DATA_DICTIONARY CURRENT_SQL_COMMANDS VIEW
283
DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS VIEW
284
DATA_DICTIONARY FOREIGN_KEYS VIEW
285
DATA_DICTIONARY GLOBAL_STATEMENTS VIEW
286
DATA_DICTIONARY GLOBAL_STATUS VIEW
287
DATA_DICTIONARY GLOBAL_VARIABLES VIEW
288
DATA_DICTIONARY INDEXES VIEW
289
DATA_DICTIONARY INDEX_PARTS VIEW
290
DATA_DICTIONARY INNODB_INTERNAL_TABLES VIEW
291
DATA_DICTIONARY INNODB_LOCKS VIEW
292
DATA_DICTIONARY INNODB_LOCK_WAITS VIEW
293
DATA_DICTIONARY INNODB_STATUS VIEW
294
DATA_DICTIONARY MODULES VIEW
295
DATA_DICTIONARY MYSQL_PROTOCOL_STATUS VIEW
296
DATA_DICTIONARY PLUGINS VIEW
297
DATA_DICTIONARY REPLICATION_STREAMS VIEW
298
DATA_DICTIONARY SCHEMAS VIEW
299
DATA_DICTIONARY SCOREBOARD_STATISTICS VIEW
300
DATA_DICTIONARY SESSION_STATEMENTS VIEW
301
DATA_DICTIONARY SESSION_STATUS VIEW
302
DATA_DICTIONARY SESSION_VARIABLES VIEW
303
DATA_DICTIONARY SHOW_COLUMNS VIEW
304
DATA_DICTIONARY SHOW_INDEXES VIEW
305
DATA_DICTIONARY SHOW_SCHEMAS VIEW
306
DATA_DICTIONARY SHOW_TABLES VIEW
307
DATA_DICTIONARY SHOW_TABLE_STATUS VIEW
308
DATA_DICTIONARY SHOW_TEMPORARY_TABLES VIEW
309
DATA_DICTIONARY TABLES VIEW
310
DATA_DICTIONARY TABLE_CONSTRAINTS VIEW
311
DATA_DICTIONARY USER_LOCKS VIEW
312
INFORMATION_SCHEMA CHECK_CONSTRAINTS VIEW
313
INFORMATION_SCHEMA COLUMNS VIEW
314
INFORMATION_SCHEMA COLUMN_PRIVILEGES VIEW
315
INFORMATION_SCHEMA DOMAINS VIEW
316
INFORMATION_SCHEMA DOMAIN_CONSTRAINTS VIEW
317
INFORMATION_SCHEMA PARAMETERS VIEW
318
INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS VIEW
319
INFORMATION_SCHEMA ROUTINES VIEW
320
INFORMATION_SCHEMA ROUTINE_COLUMNS VIEW
321
INFORMATION_SCHEMA TABLES VIEW
322
INFORMATION_SCHEMA TABLE_CONSTRAINTS VIEW
323
INFORMATION_SCHEMA TABLE_PRIVILEGES VIEW
324
INFORMATION_SCHEMA VIEWS VIEW
325
a ds BASE
277
LOCAL DATA_DICTIONARY CHARACTER_SETS VIEW
278
LOCAL DATA_DICTIONARY COLLATIONS VIEW
279
LOCAL DATA_DICTIONARY COLUMNS VIEW
280
LOCAL DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
281
LOCAL DATA_DICTIONARY CUMULATIVE_USER_STATS VIEW
282
LOCAL DATA_DICTIONARY CURRENT_SQL_COMMANDS VIEW
283
LOCAL DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS VIEW
284
LOCAL DATA_DICTIONARY FOREIGN_KEYS VIEW
285
LOCAL DATA_DICTIONARY GLOBAL_STATEMENTS VIEW
286
LOCAL DATA_DICTIONARY GLOBAL_STATUS VIEW
287
LOCAL DATA_DICTIONARY GLOBAL_VARIABLES VIEW
288
LOCAL DATA_DICTIONARY INDEXES VIEW
289
LOCAL DATA_DICTIONARY INDEX_PARTS VIEW
290
LOCAL DATA_DICTIONARY INNODB_INTERNAL_TABLES VIEW
291
LOCAL DATA_DICTIONARY INNODB_LOCKS VIEW
292
LOCAL DATA_DICTIONARY INNODB_LOCK_WAITS VIEW
293
LOCAL DATA_DICTIONARY INNODB_STATUS VIEW
294
LOCAL DATA_DICTIONARY MODULES VIEW
295
LOCAL DATA_DICTIONARY MYSQL_PROTOCOL_STATUS VIEW
296
LOCAL DATA_DICTIONARY PLUGINS VIEW
297
LOCAL DATA_DICTIONARY REPLICATION_STREAMS VIEW
298
LOCAL DATA_DICTIONARY SCHEMAS VIEW
299
LOCAL DATA_DICTIONARY SCOREBOARD_STATISTICS VIEW
300
LOCAL DATA_DICTIONARY SESSION_STATEMENTS VIEW
301
LOCAL DATA_DICTIONARY SESSION_STATUS VIEW
302
LOCAL DATA_DICTIONARY SESSION_VARIABLES VIEW
303
LOCAL DATA_DICTIONARY SHOW_COLUMNS VIEW
304
LOCAL DATA_DICTIONARY SHOW_INDEXES VIEW
305
LOCAL DATA_DICTIONARY SHOW_SCHEMAS VIEW
306
LOCAL DATA_DICTIONARY SHOW_TABLES VIEW
307
LOCAL DATA_DICTIONARY SHOW_TABLE_STATUS VIEW
308
LOCAL DATA_DICTIONARY SHOW_TEMPORARY_TABLES VIEW
309
LOCAL DATA_DICTIONARY TABLES VIEW
310
LOCAL DATA_DICTIONARY TABLE_CONSTRAINTS VIEW
311
LOCAL DATA_DICTIONARY USER_LOCKS VIEW
312
LOCAL INFORMATION_SCHEMA CHECK_CONSTRAINTS VIEW
313
LOCAL INFORMATION_SCHEMA COLUMNS VIEW
314
LOCAL INFORMATION_SCHEMA COLUMN_PRIVILEGES VIEW
315
LOCAL INFORMATION_SCHEMA DOMAINS VIEW
316
LOCAL INFORMATION_SCHEMA DOMAIN_CONSTRAINTS VIEW
317
LOCAL INFORMATION_SCHEMA PARAMETERS VIEW
318
LOCAL INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS VIEW
319
LOCAL INFORMATION_SCHEMA ROUTINES VIEW
320
LOCAL INFORMATION_SCHEMA ROUTINE_COLUMNS VIEW
321
LOCAL INFORMATION_SCHEMA TABLES VIEW
322
LOCAL INFORMATION_SCHEMA TABLE_CONSTRAINTS VIEW
323
LOCAL INFORMATION_SCHEMA TABLE_PRIVILEGES VIEW
324
LOCAL INFORMATION_SCHEMA VIEWS VIEW
325
LOCAL a ds BASE
326
326
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="a" ORDER BY TABLE_NAME;
327
327
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
328
a a BASE
329
a aa BASE
330
a b BASE
331
a c BASE
332
a d BASE
333
a ds BASE
328
LOCAL a a BASE
329
LOCAL a aa BASE
330
LOCAL a b BASE
331
LOCAL a c BASE
332
LOCAL a d BASE
333
LOCAL a ds BASE
334
334
drop schema a;
335
335
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="a";
336
336
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
Loggerhead is a web-based interface for Breezy
Version: 2.0.1