1
use information_schema;
2
SHOW CREATE TABLE `CHECK_CONSTRAINTS`;
4
CHECK_CONSTRAINTS CREATE TABLE `check_constraints` (
5
`CONSTRAINT_CATALOG` varchar(64) NOT NULL DEFAULT '',
6
`CONSTRAINT_SCHEMA` varchar(64) NOT NULL DEFAULT '',
7
`CONSTRAINT_NAME` varchar(64) NOT NULL DEFAULT '',
8
`CHECK_CLAUSE` varchar(64) NOT NULL DEFAULT ''
9
) ENGINE=FunctionEngine
10
SHOW CREATE TABLE `COLUMNS`;
12
COLUMNS CREATE TABLE `columns` (
13
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
14
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
15
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
16
`COLUMN_NAME` varchar(64) NOT NULL DEFAULT '',
17
`ORDINAL_POSITION` varchar(64) NOT NULL DEFAULT '',
18
`COLUMN_DEFAULT` varchar(64) NOT NULL DEFAULT '',
19
`IS_NULLABLE` varchar(64) NOT NULL DEFAULT '',
20
`DATA_TYPE` varchar(64) NOT NULL DEFAULT '',
21
`CHARACTER_MAXIMUM_LENGTH` varchar(64) NOT NULL DEFAULT '',
22
`CHARACTER_OCTET_LENGTH` varchar(64) NOT NULL DEFAULT '',
23
`NUMERIC_PRECISION` varchar(64) NOT NULL DEFAULT '',
24
`NUMERIC_PRECISION_RADIX` varchar(64) NOT NULL DEFAULT '',
25
`NUMERIC_SCALE` varchar(64) NOT NULL DEFAULT '',
26
`DATETIME_PRECISION` varchar(64) NOT NULL DEFAULT '',
27
`CHARACTER_SET_CATALOG` varchar(64) NOT NULL DEFAULT '',
28
`CHARACTER_SET_SCHEMA` varchar(64) NOT NULL DEFAULT '',
29
`CHARACTER_SET_NAME` varchar(64) NOT NULL DEFAULT '',
30
`COLLATION_CATALOG` varchar(64) NOT NULL DEFAULT '',
31
`COLLATION_SCHEMA` varchar(64) NOT NULL DEFAULT '',
32
`COLLATION_NAME` varchar(64) NOT NULL DEFAULT '',
33
`DOMAIN_CATALOG` varchar(64) NOT NULL DEFAULT '',
34
`DOMAIN_SCHEMA` varchar(64) NOT NULL DEFAULT '',
35
`DOMAIN_NAME` varchar(64) NOT NULL DEFAULT ''
36
) ENGINE=FunctionEngine
37
SHOW CREATE TABLE `COLUMN_DOMAIN_USAGE`;
39
COLUMN_DOMAIN_USAGE CREATE TABLE `column_domain_usage` (
40
`DOMAIN_CATALOG` varchar(64) NOT NULL DEFAULT '',
41
`DOMAIN_SCHEMA` varchar(64) NOT NULL DEFAULT '',
42
`DOMAIN_NAME` varchar(64) NOT NULL DEFAULT '',
43
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
44
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
45
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
46
`COLUMN_NAME` varchar(64) NOT NULL DEFAULT ''
47
) ENGINE=FunctionEngine
48
SHOW CREATE TABLE `COLUMN_PRIVILEGES`;
50
COLUMN_PRIVILEGES CREATE TABLE `column_privileges` (
51
`GRANTOR` varchar(64) NOT NULL DEFAULT '',
52
`GRANTEE` varchar(64) NOT NULL DEFAULT '',
53
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
54
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
55
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
56
`COLUMN_NAME` varchar(64) NOT NULL DEFAULT '',
57
`PRIVILEGE_TYPE` varchar(64) NOT NULL DEFAULT '',
58
`IS_GRANTABLE` varchar(64) NOT NULL DEFAULT ''
59
) ENGINE=FunctionEngine
60
SHOW CREATE TABLE `CONSTRAINT_COLUMN_USAGE`;
62
CONSTRAINT_COLUMN_USAGE CREATE TABLE `constraint_column_usage` (
63
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
64
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
65
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
66
`COLUMN_NAME` varchar(64) NOT NULL DEFAULT '',
67
`CONSTRAINT_CATALOG` varchar(64) NOT NULL DEFAULT '',
68
`CONSTRAINT_SCHEMA` varchar(64) NOT NULL DEFAULT '',
69
`CONSTRAINT_NAME` varchar(64) NOT NULL DEFAULT ''
70
) ENGINE=FunctionEngine
71
SHOW CREATE TABLE `CONSTRAINT_TABLE_USAGE`;
73
CONSTRAINT_TABLE_USAGE CREATE TABLE `constraint_table_usage` (
74
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
75
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
76
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
77
`CONSTRAINT_CATALOG` varchar(64) NOT NULL DEFAULT '',
78
`CONSTRAINT_SCHEMA` varchar(64) NOT NULL DEFAULT '',
79
`CONSTRAINT_NAME` varchar(64) NOT NULL DEFAULT ''
80
) ENGINE=FunctionEngine
81
SHOW CREATE TABLE `DOMAINS`;
83
DOMAINS CREATE TABLE `domains` (
84
`DOMAIN_CATALOG` varchar(64) NOT NULL DEFAULT '',
85
`DOMAIN_SCHEMA` varchar(64) NOT NULL DEFAULT '',
86
`DOMAIN_NAME` varchar(64) NOT NULL DEFAULT '',
87
`DATA_TYPE` varchar(64) NOT NULL DEFAULT '',
88
`CHARACTER_MAXIMUM_LENGTH` varchar(64) NOT NULL DEFAULT '',
89
`CHARACTER_OCTET_LENGTH` varchar(64) NOT NULL DEFAULT '',
90
`COLLATION_CATALOG` varchar(64) NOT NULL DEFAULT '',
91
`COLLATION_SCHEMA` varchar(64) NOT NULL DEFAULT '',
92
`COLLATION_NAME` varchar(64) NOT NULL DEFAULT '',
93
`CHARACTER_SET_CATALOG` varchar(64) NOT NULL DEFAULT '',
94
`CHARACTER_SET_SCHEMA` varchar(64) NOT NULL DEFAULT '',
95
`CHARACTER_SET_NAME` varchar(64) NOT NULL DEFAULT '',
96
`NUMERIC_PRECISION` varchar(64) NOT NULL DEFAULT '',
97
`NUMERIC_PRECISION_RADIX` varchar(64) NOT NULL DEFAULT '',
98
`NUMERIC_SCALE` varchar(64) NOT NULL DEFAULT '',
99
`DATETIME_PRECISION` varchar(64) NOT NULL DEFAULT '',
100
`DOMAIN_DEFAULT` varchar(64) NOT NULL DEFAULT ''
101
) ENGINE=FunctionEngine
102
SHOW CREATE TABLE `DOMAIN_CONSTRAINTS`;
104
DOMAIN_CONSTRAINTS CREATE TABLE `domain_constraints` (
105
`CONSTRAINT_CATALOG` varchar(64) NOT NULL DEFAULT '',
106
`CONSTRAINT_SCHEMA` varchar(64) NOT NULL DEFAULT '',
107
`CONSTRAINT_NAME` varchar(64) NOT NULL DEFAULT '',
108
`DOMAIN_CATALOG` varchar(64) NOT NULL DEFAULT '',
109
`DOMAIN_SCHEMA` varchar(64) NOT NULL DEFAULT '',
110
`DOMAIN_NAME` varchar(64) NOT NULL DEFAULT '',
111
`IS_DEFERRABLE` varchar(64) NOT NULL DEFAULT '',
112
`INITIALLY_DEFERRED` varchar(64) NOT NULL DEFAULT ''
113
) ENGINE=FunctionEngine
114
SHOW CREATE TABLE `KEY_COLUMN_USAGE`;
116
KEY_COLUMN_USAGE CREATE TABLE `key_column_usage` (
117
`CONSTRAINT_CATALOG` varchar(64) NOT NULL DEFAULT '',
118
`CONSTRAINT_SCHEMA` varchar(64) NOT NULL DEFAULT '',
119
`CONSTRAINT_NAME` varchar(64) NOT NULL DEFAULT '',
120
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
121
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
122
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
123
`COLUMN_NAME` varchar(64) NOT NULL DEFAULT '',
124
`ORDINAL_POSITION` varchar(64) NOT NULL DEFAULT ''
125
) ENGINE=FunctionEngine
126
SHOW CREATE TABLE `PARAMETERS`;
128
PARAMETERS CREATE TABLE `parameters` (
129
`SPECIFIC_CATALOG` varchar(64) NOT NULL DEFAULT '',
130
`SPECIFIC_SCHEMA` varchar(64) NOT NULL DEFAULT '',
131
`SPECIFIC_NAME` varchar(64) NOT NULL DEFAULT '',
132
`ORDINAL_POSITION` varchar(64) NOT NULL DEFAULT '',
133
`PARAMETER_MODE` varchar(64) NOT NULL DEFAULT '',
134
`IS_RESULT` varchar(64) NOT NULL DEFAULT '',
135
`AS_LOCATOR` varchar(64) NOT NULL DEFAULT '',
136
`PARAMETER_NAME` varchar(64) NOT NULL DEFAULT '',
137
`DATA_TYPE` varchar(64) NOT NULL DEFAULT '',
138
`CHARACTER_MAXIMUM_LENGTH` varchar(64) NOT NULL DEFAULT '',
139
`CHARACTER_OCTET_LENGTH` varchar(64) NOT NULL DEFAULT '',
140
`CHARACTER_OCTET_LENGTH` varchar(64) NOT NULL DEFAULT '',
141
`COLLATION_CATALOG` varchar(64) NOT NULL DEFAULT '',
142
`COLLATION_SCHEMA` varchar(64) NOT NULL DEFAULT '',
143
`COLLATION_NAME` varchar(64) NOT NULL DEFAULT '',
144
`CHARACTER_SET_CATALOG` varchar(64) NOT NULL DEFAULT '',
145
`CHARACTER_SET_SCHEMA` varchar(64) NOT NULL DEFAULT '',
146
`CHARACTER_SET_NAME` varchar(64) NOT NULL DEFAULT '',
147
`NUMERIC_PRECISION` varchar(64) NOT NULL DEFAULT '',
148
`NUMERIC_PRECISION_RADIX` varchar(64) NOT NULL DEFAULT '',
149
`NUMERIC_SCALE` varchar(64) NOT NULL DEFAULT '',
150
`DATETIME_PRECISION` varchar(64) NOT NULL DEFAULT '',
151
`INTERVAL_TYPE` varchar(64) NOT NULL DEFAULT '',
152
`INTERVAL_PRECISION` varchar(64) NOT NULL DEFAULT '',
153
`USER_DEFINED_TYPE_CATALOG` varchar(64) NOT NULL DEFAULT '',
154
`USER_DEFINED_TYPE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
155
`USER_DEFINED_TYPE_NAME` varchar(64) NOT NULL DEFAULT '',
156
`SCOPE_CATALOG` varchar(64) NOT NULL DEFAULT '',
157
`SCOPE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
158
`SCOPE_NAME` varchar(64) NOT NULL DEFAULT ''
159
) ENGINE=FunctionEngine
160
SHOW CREATE TABLE `REFERENTIAL_CONSTRAINTS`;
162
REFERENTIAL_CONSTRAINTS CREATE TABLE `referential_constraints` (
163
`CONSTRAINT_CATALOG` varchar(64) NOT NULL DEFAULT '',
164
`CONSTRAINT_SCHEMA` varchar(64) NOT NULL DEFAULT '',
165
`CONSTRAINT_NAME` varchar(64) NOT NULL DEFAULT '',
166
`UNIQUE_CONSTRAINT_CATALOG` varchar(64) NOT NULL DEFAULT '',
167
`UNIQUE_CONSTRAINT_SCHEMA` varchar(64) NOT NULL DEFAULT '',
168
`UNIQUE_CONSTRAINT_NAME` varchar(64) NOT NULL DEFAULT '',
169
`MATCH_OPTION` varchar(64) NOT NULL DEFAULT '',
170
`UPDATE_RULE` varchar(64) NOT NULL DEFAULT '',
171
`DELETE_RULE` varchar(64) NOT NULL DEFAULT ''
172
) ENGINE=FunctionEngine
173
SHOW CREATE TABLE `ROUTINES`;
175
ROUTINES CREATE TABLE `routines` (
176
`SPECIFIC_CATALOG` varchar(64) NOT NULL DEFAULT '',
177
`SPECIFIC_SCHEMA` varchar(64) NOT NULL DEFAULT '',
178
`SPECIFIC_NAME` varchar(64) NOT NULL DEFAULT '',
179
`ROUTINE_CATALOG` varchar(64) NOT NULL DEFAULT '',
180
`ROUTINE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
181
`ROUTINE_NAME` varchar(64) NOT NULL DEFAULT '',
182
`MODULE_CATALOG` varchar(64) NOT NULL DEFAULT '',
183
`MODULE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
184
`MODULE_NAME` varchar(64) NOT NULL DEFAULT '',
185
`UDT_CATALOG` varchar(64) NOT NULL DEFAULT '',
186
`UDT_SCHEMA` varchar(64) NOT NULL DEFAULT '',
187
`UDT_NAME` varchar(64) NOT NULL DEFAULT '',
188
`DATA_TYPE` varchar(64) NOT NULL DEFAULT '',
189
`CHARACTER_MAXIMUM_LENGTH` varchar(64) NOT NULL DEFAULT '',
190
`CHARACTER_OCTET_LENGTH` varchar(64) NOT NULL DEFAULT '',
191
`COLLATION_CATALOG` varchar(64) NOT NULL DEFAULT '',
192
`COLLATION_SCHEMA` varchar(64) NOT NULL DEFAULT '',
193
`COLLATION_NAME` varchar(64) NOT NULL DEFAULT '',
194
`CHARACTER_SET_CATALOG` varchar(64) NOT NULL DEFAULT '',
195
`CHARACTER_SET_SCHEMA` varchar(64) NOT NULL DEFAULT '',
196
`CHARACTER_SET_NAME` varchar(64) NOT NULL DEFAULT '',
197
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
198
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
199
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
200
`NUMERIC_PRECISION` varchar(64) NOT NULL DEFAULT '',
201
`NUMERIC_PRECISION_RADIX` varchar(64) NOT NULL DEFAULT '',
202
`NUMERIC_SCALE` varchar(64) NOT NULL DEFAULT '',
203
`DATETIME_PRECISION` varchar(64) NOT NULL DEFAULT '',
204
`INTERVAL_TYPE` varchar(64) NOT NULL DEFAULT '',
205
`INTERVAL_PRECISION` varchar(64) NOT NULL DEFAULT '',
206
`TYPE_UDT_CATALOG` varchar(64) NOT NULL DEFAULT '',
207
`TYPE_UDT_SCHEMA` varchar(64) NOT NULL DEFAULT '',
208
`TYPE_UDT_NAME` varchar(64) NOT NULL DEFAULT '',
209
`SCOPE_CATALOG` varchar(64) NOT NULL DEFAULT '',
210
`SCOPE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
211
`SCOPE_NAME` varchar(64) NOT NULL DEFAULT '',
212
`MAXIMUM_CARDINALITY` varchar(64) NOT NULL DEFAULT '',
213
`DTD_IDENTIFIER` varchar(64) NOT NULL DEFAULT '',
214
`ROUTINE_BODY` varchar(64) NOT NULL DEFAULT '',
215
`ROUTINE_DEFINITION` varchar(64) NOT NULL DEFAULT '',
216
`EXTERNAL_NAME` varchar(64) NOT NULL DEFAULT '',
217
`EXTERNAL_LANGUAGE` varchar(64) NOT NULL DEFAULT '',
218
`PARAMETER_STYLE` varchar(64) NOT NULL DEFAULT '',
219
`IS_DETERMINISTIC` varchar(64) NOT NULL DEFAULT '',
220
`SQL_DATA_ACCESS` varchar(64) NOT NULL DEFAULT '',
221
`IS_NULL_CALL` varchar(64) NOT NULL DEFAULT '',
222
`SQL_PATH` varchar(64) NOT NULL DEFAULT '',
223
`SCHEMA_LEVEL_ROUTINE` varchar(64) NOT NULL DEFAULT '',
224
`MAX_DYNAMIC_RESULT_SETS` varchar(64) NOT NULL DEFAULT '',
225
`IS_USER_DEFINED_CAST` varchar(64) NOT NULL DEFAULT '',
226
`IS_IMPLICITLY_INVOCABLE` varchar(64) NOT NULL DEFAULT '',
227
`CREATED` varchar(64) NOT NULL DEFAULT '',
228
`LAST_ALTERED` varchar(64) NOT NULL DEFAULT ''
229
) ENGINE=FunctionEngine
230
SHOW CREATE TABLE `ROUTINE_COLUMNS`;
232
ROUTINE_COLUMNS CREATE TABLE `routine_columns` (
233
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
234
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
235
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
236
`COLUMN_NAME` varchar(64) NOT NULL DEFAULT '',
237
`ORDINAL_POSITION` varchar(64) NOT NULL DEFAULT '',
238
`COLUMN_DEFAULT` varchar(64) NOT NULL DEFAULT '',
239
`IS_NULLABLE` varchar(64) NOT NULL DEFAULT '',
240
`DATA_TYPE` varchar(64) NOT NULL DEFAULT '',
241
`CHARACTER_MAXIMUM_LENGTH` varchar(64) NOT NULL DEFAULT '',
242
`CHARACTER_OCTET_LENGTH` varchar(64) NOT NULL DEFAULT '',
243
`NUMERIC_PRECISION` varchar(64) NOT NULL DEFAULT '',
244
`NUMERIC_PRECISION_RADIX` varchar(64) NOT NULL DEFAULT '',
245
`NUMERIC_SCALE` varchar(64) NOT NULL DEFAULT '',
246
`DATETIME_PRECISION` varchar(64) NOT NULL DEFAULT '',
247
`CHARACTER_SET_CATALOG` varchar(64) NOT NULL DEFAULT '',
248
`CHARACTER_SET_SCHEMA` varchar(64) NOT NULL DEFAULT '',
249
`CHARACTER_SET_NAME` varchar(64) NOT NULL DEFAULT '',
250
`COLLATION_CATALOG` varchar(64) NOT NULL DEFAULT '',
251
`COLLATION_SCHEMA` varchar(64) NOT NULL DEFAULT '',
252
`COLLATION_NAME` varchar(64) NOT NULL DEFAULT '',
253
`DOMAIN_CATALOG` varchar(64) NOT NULL DEFAULT '',
254
`DOMAIN_SCHEMA` varchar(64) NOT NULL DEFAULT '',
255
`DOMAIN_NAME` varchar(64) NOT NULL DEFAULT ''
256
) ENGINE=FunctionEngine
257
SHOW CREATE TABLE `SCHEMATA`;
259
SCHEMATA CREATE TABLE `schemata` (
260
`CATALOG_NAME` varchar(64) NOT NULL DEFAULT '',
261
`SCHEMA_NAME` varchar(64) NOT NULL DEFAULT '',
262
`SCHEMA_OWNER` varchar(64) NOT NULL DEFAULT '',
263
`DEFAULT_CHARACTER_SET_CATALOG` varchar(64) NOT NULL DEFAULT '',
264
`DEFAULT_CHARACTER_SET_SCHEMA` varchar(64) NOT NULL DEFAULT '',
265
`DEFAULT_CHARACTER_SET_NAME` varchar(64) NOT NULL DEFAULT ''
266
) ENGINE=FunctionEngine
267
SHOW CREATE TABLE `TABLES`;
269
TABLES CREATE TABLE `tables` (
270
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
271
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
272
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
273
`TABLE_TYPE` varchar(64) NOT NULL DEFAULT ''
274
) ENGINE=FunctionEngine
275
SHOW CREATE TABLE `TABLE_CONSTRAINTS`;
277
TABLE_CONSTRAINTS CREATE TABLE `table_constraints` (
278
`CONSTRAINT_CATALOG` varchar(64) NOT NULL DEFAULT '',
279
`CONSTRAINT_SCHEMA` varchar(64) NOT NULL DEFAULT '',
280
`CONSTRAINT_NAME` varchar(64) NOT NULL DEFAULT '',
281
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
282
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
283
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
284
`CONSTRAINT_TYPE` varchar(64) NOT NULL DEFAULT '',
285
`IS_DEFERRABLE` varchar(64) NOT NULL DEFAULT '',
286
`INITIALLY_DEFERRED` varchar(64) NOT NULL DEFAULT ''
287
) ENGINE=FunctionEngine
288
SHOW CREATE TABLE `TABLE_PRIVILEDGES`;
290
TABLE_PRIVILEDGES CREATE TABLE `table_priviledges` (
291
`GRANTOR` varchar(64) NOT NULL DEFAULT '',
292
`GRANTEE` varchar(64) NOT NULL DEFAULT '',
293
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
294
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
295
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
296
`COLUMN_NAME` varchar(64) NOT NULL DEFAULT '',
297
`PRIVILEGE_TYPE` varchar(64) NOT NULL DEFAULT '',
298
`IS_GRANTABLE` varchar(64) NOT NULL DEFAULT ''
299
) ENGINE=FunctionEngine
300
SHOW CREATE TABLE `VIEWS`;
302
VIEWS CREATE TABLE `views` (
303
`VIEW_CATALOG` varchar(64) NOT NULL DEFAULT '',
304
`VIEW_SCHEMA` varchar(64) NOT NULL DEFAULT '',
305
`VIEW_NAME` varchar(64) NOT NULL DEFAULT '',
306
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
307
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
308
`TABLE_NAME` varchar(64) NOT NULL DEFAULT ''
309
) ENGINE=FunctionEngine
310
SHOW CREATE TABLE `VIEW_COLUMN_USAGE`;
312
VIEW_COLUMN_USAGE CREATE TABLE `view_column_usage` (
313
`VIEW_CATALOG` varchar(64) NOT NULL DEFAULT '',
314
`VIEW_SCHEMA` varchar(64) NOT NULL DEFAULT '',
315
`VIEW_NAME` varchar(64) NOT NULL DEFAULT '',
316
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
317
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
318
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
319
`COLUMN_NAME` varchar(64) NOT NULL DEFAULT ''
320
) ENGINE=FunctionEngine
321
SHOW CREATE TABLE `VIEW_TABLE_USAGE`;
323
VIEW_TABLE_USAGE CREATE TABLE `view_table_usage` (
324
`TABLE_CATALOG` varchar(64) NOT NULL DEFAULT '',
325
`TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
326
`TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
327
`VIEW_DEFINITION` varchar(64) NOT NULL DEFAULT '',
328
`CHECK_OPTION` varchar(64) NOT NULL DEFAULT '',
329
`IS_UPDATABLE` varchar(64) NOT NULL DEFAULT ''
330
) ENGINE=FunctionEngine