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