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