← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to plugin/information_schema_dictionary/tests/r/tables.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-10-02 14:17:48 UTC
  • mfrom: (1.1.1 upstream)
  • mto: (2.1.17 sid)
  • mto: This revision was merged to the branch mainline in revision 3.
  • Revision ID: james.westby@ubuntu.com-20101002141748-m6vbfbfjhrw1153e
Tags: 2010.09.1802-1
* New upstream release.
* Removed pid-file argument hack.
* Updated GPL-2 address to be new address.
* Directly copy in drizzledump.1 since debian doesn't have sphinx 1.0 yet.
* Link to jquery from libjs-jquery. Add it as a depend.
* Add drizzled.8 symlink to the install files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/information_schema_dictionary/tests/r/tables.result
 
1
select * from INFORMATION_SCHEMA.SCHEMATA;
 
2
CATALOG_NAME    SCHEMA_NAME     SCHEMA_OWNER    DEFAULT_CHARACTER_SET_CATALOG   DEFAULT_CHARACTER_SET_SCHEMA    DEFAULT_CHARACTER_SET_NAME
 
3
        data_dictionary                         
 
4
        information_schema                              
 
5
        mysql                           
 
6
        test                            
 
7
select * from INFORMATION_SCHEMA.TABLES;
 
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 COUNTER VIEW
 
13
        DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
 
14
        DATA_DICTIONARY CUMULATIVE_USER_STATS   VIEW
 
15
        DATA_DICTIONARY CURRENT_SQL_COMMANDS    VIEW
 
16
        DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS 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 RANDOM_NUMBER   VIEW
 
36
        DATA_DICTIONARY RANDOM_STRING   VIEW
 
37
        DATA_DICTIONARY REFERENTIAL_CONSTRAINTS VIEW
 
38
        DATA_DICTIONARY REPLICATION_STREAMS     VIEW
 
39
        DATA_DICTIONARY SCHEMAS VIEW
 
40
        DATA_DICTIONARY SCOREBOARD_STATISTICS   VIEW
 
41
        DATA_DICTIONARY SESSION_STATEMENTS      VIEW
 
42
        DATA_DICTIONARY SESSION_STATUS  VIEW
 
43
        DATA_DICTIONARY SESSION_VARIABLES       VIEW
 
44
        DATA_DICTIONARY SHOW_COLUMNS    VIEW
 
45
        DATA_DICTIONARY SHOW_INDEXES    VIEW
 
46
        DATA_DICTIONARY SHOW_SCHEMAS    VIEW
 
47
        DATA_DICTIONARY SHOW_TABLES     VIEW
 
48
        DATA_DICTIONARY SHOW_TABLE_STATUS       VIEW
 
49
        DATA_DICTIONARY SHOW_TEMPORARY_TABLES   VIEW
 
50
        DATA_DICTIONARY TABLES  VIEW
 
51
        DATA_DICTIONARY TABLE_CACHE     VIEW
 
52
        DATA_DICTIONARY TABLE_CONSTRAINTS       VIEW
 
53
        DATA_DICTIONARY TABLE_DEFINITION_CACHE  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
 
74
use information_schema;
 
75
show schemas;
 
76
Database
 
77
DATA_DICTIONARY
 
78
INFORMATION_SCHEMA
 
79
mysql
 
80
test
 
81
select * from INFORMATION_SCHEMA.TABLES;
 
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 COUNTER VIEW
 
87
        DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
 
88
        DATA_DICTIONARY CUMULATIVE_USER_STATS   VIEW
 
89
        DATA_DICTIONARY CURRENT_SQL_COMMANDS    VIEW
 
90
        DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS 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 RANDOM_NUMBER   VIEW
 
110
        DATA_DICTIONARY RANDOM_STRING   VIEW
 
111
        DATA_DICTIONARY REFERENTIAL_CONSTRAINTS VIEW
 
112
        DATA_DICTIONARY REPLICATION_STREAMS     VIEW
 
113
        DATA_DICTIONARY SCHEMAS VIEW
 
114
        DATA_DICTIONARY SCOREBOARD_STATISTICS   VIEW
 
115
        DATA_DICTIONARY SESSION_STATEMENTS      VIEW
 
116
        DATA_DICTIONARY SESSION_STATUS  VIEW
 
117
        DATA_DICTIONARY SESSION_VARIABLES       VIEW
 
118
        DATA_DICTIONARY SHOW_COLUMNS    VIEW
 
119
        DATA_DICTIONARY SHOW_INDEXES    VIEW
 
120
        DATA_DICTIONARY SHOW_SCHEMAS    VIEW
 
121
        DATA_DICTIONARY SHOW_TABLES     VIEW
 
122
        DATA_DICTIONARY SHOW_TABLE_STATUS       VIEW
 
123
        DATA_DICTIONARY SHOW_TEMPORARY_TABLES   VIEW
 
124
        DATA_DICTIONARY TABLES  VIEW
 
125
        DATA_DICTIONARY TABLE_CACHE     VIEW
 
126
        DATA_DICTIONARY TABLE_CONSTRAINTS       VIEW
 
127
        DATA_DICTIONARY TABLE_DEFINITION_CACHE  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
 
148
select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG=NULL;
 
149
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
150
select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=NULL;
 
151
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
152
select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME=NULL;
 
153
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
154
select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="information_schema" AND TABLE_TYPE="STANDARD";
 
155
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
156
select * from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="information_schema" AND TABLE_TYPE="VIEW";
 
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
 
178
select * from INFORMATION_SCHEMA.TABLES ORDER BY TABLE_SCHEMA, TABLE_NAME;
 
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 COUNTER VIEW
 
184
        DATA_DICTIONARY CUMULATIVE_SQL_COMMANDS VIEW
 
185
        DATA_DICTIONARY CUMULATIVE_USER_STATS   VIEW
 
186
        DATA_DICTIONARY CURRENT_SQL_COMMANDS    VIEW
 
187
        DATA_DICTIONARY DRIZZLE_PROTOCOL_STATUS 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 RANDOM_NUMBER   VIEW
 
207
        DATA_DICTIONARY RANDOM_STRING   VIEW
 
208
        DATA_DICTIONARY REFERENTIAL_CONSTRAINTS VIEW
 
209
        DATA_DICTIONARY REPLICATION_STREAMS     VIEW
 
210
        DATA_DICTIONARY SCHEMAS VIEW
 
211
        DATA_DICTIONARY SCOREBOARD_STATISTICS   VIEW
 
212
        DATA_DICTIONARY SESSION_STATEMENTS      VIEW
 
213
        DATA_DICTIONARY SESSION_STATUS  VIEW
 
214
        DATA_DICTIONARY SESSION_VARIABLES       VIEW
 
215
        DATA_DICTIONARY SHOW_COLUMNS    VIEW
 
216
        DATA_DICTIONARY SHOW_INDEXES    VIEW
 
217
        DATA_DICTIONARY SHOW_SCHEMAS    VIEW
 
218
        DATA_DICTIONARY SHOW_TABLES     VIEW
 
219
        DATA_DICTIONARY SHOW_TABLE_STATUS       VIEW
 
220
        DATA_DICTIONARY SHOW_TEMPORARY_TABLES   VIEW
 
221
        DATA_DICTIONARY TABLES  VIEW
 
222
        DATA_DICTIONARY TABLE_CACHE     VIEW
 
223
        DATA_DICTIONARY TABLE_CONSTRAINTS       VIEW
 
224
        DATA_DICTIONARY TABLE_DEFINITION_CACHE  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
 
245
create schema a;
 
246
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="a";
 
247
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
248
use a;
 
249
create table a (a int );
 
250
create table b (a int );
 
251
create table c (a int );
 
252
create table d (a int );
 
253
create table ds (a int );
 
254
create table aa (a int );
 
255
show tables;
 
256
Tables_in_a
 
257
a
 
258
aa
 
259
b
 
260
c
 
261
d
 
262
ds
 
263
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME="a";
 
264
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
265
        a       a       BASE
 
266
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like "a%";
 
267
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
268
        a       a       BASE
 
269
        a       aa      BASE
 
270
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like "%a";
 
271
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
272
        INFORMATION_SCHEMA      SCHEMATA        VIEW
 
273
        a       a       BASE
 
274
        a       aa      BASE
 
275
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like "%s";
 
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 GLOBAL_STATEMENTS       VIEW
 
285
        DATA_DICTIONARY GLOBAL_STATUS   VIEW
 
286
        DATA_DICTIONARY GLOBAL_VARIABLES        VIEW
 
287
        DATA_DICTIONARY INDEXES VIEW
 
288
        DATA_DICTIONARY INDEX_PARTS     VIEW
 
289
        DATA_DICTIONARY INNODB_INTERNAL_TABLES  VIEW
 
290
        DATA_DICTIONARY INNODB_LOCKS    VIEW
 
291
        DATA_DICTIONARY INNODB_LOCK_WAITS       VIEW
 
292
        DATA_DICTIONARY INNODB_STATUS   VIEW
 
293
        DATA_DICTIONARY MODULES VIEW
 
294
        DATA_DICTIONARY MYSQL_PROTOCOL_STATUS   VIEW
 
295
        DATA_DICTIONARY PLUGINS VIEW
 
296
        DATA_DICTIONARY REFERENTIAL_CONSTRAINTS 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
        INFORMATION_SCHEMA      CHECK_CONSTRAINTS       VIEW
 
312
        INFORMATION_SCHEMA      COLUMNS VIEW
 
313
        INFORMATION_SCHEMA      COLUMN_PRIVILEGES       VIEW
 
314
        INFORMATION_SCHEMA      DOMAINS VIEW
 
315
        INFORMATION_SCHEMA      DOMAIN_CONSTRAINTS      VIEW
 
316
        INFORMATION_SCHEMA      PARAMETERS      VIEW
 
317
        INFORMATION_SCHEMA      REFERENTIAL_CONSTRAINTS VIEW
 
318
        INFORMATION_SCHEMA      ROUTINES        VIEW
 
319
        INFORMATION_SCHEMA      ROUTINE_COLUMNS VIEW
 
320
        INFORMATION_SCHEMA      TABLES  VIEW
 
321
        INFORMATION_SCHEMA      TABLE_CONSTRAINTS       VIEW
 
322
        INFORMATION_SCHEMA      TABLE_PRIVILEGES        VIEW
 
323
        INFORMATION_SCHEMA      VIEWS   VIEW
 
324
        a       ds      BASE
 
325
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="a" ORDER BY TABLE_NAME;
 
326
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE
 
327
        a       a       BASE
 
328
        a       aa      BASE
 
329
        a       b       BASE
 
330
        a       c       BASE
 
331
        a       d       BASE
 
332
        a       ds      BASE
 
333
drop schema a;
 
334
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="a";
 
335
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE