1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
SHOW COLUMNS FROM data_dictionary.columns;
Field Type Null Default Default_is_NULL On_Update
TABLE_SCHEMA VARCHAR NO NO
TABLE_NAME VARCHAR NO NO
COLUMN_NAME VARCHAR NO NO
COLUMN_TYPE VARCHAR NO NO
ORDINAL_POSITION BIGINT NO NO
COLUMN_DEFAULT VARBINARY YES YES
COLUMN_DEFAULT_IS_NULL BOOLEAN NO NO
COLUMN_DEFAULT_UPDATE VARCHAR NO NO
IS_SIGNED BOOLEAN YES YES
IS_AUTO_INCREMENT BOOLEAN NO NO
IS_NULLABLE BOOLEAN NO NO
IS_INDEXED BOOLEAN NO NO
IS_USED_IN_PRIMARY BOOLEAN NO NO
IS_UNIQUE BOOLEAN NO NO
IS_MULTI BOOLEAN NO NO
IS_FIRST_IN_MULTI BOOLEAN NO NO
INDEXES_FOUND_IN BIGINT NO NO
DATA_TYPE VARCHAR NO NO
DATA_ARCHETYPE VARCHAR NO NO
CHARACTER_MAXIMUM_LENGTH BIGINT YES YES
CHARACTER_OCTET_LENGTH BIGINT YES YES
NUMERIC_PRECISION BIGINT YES YES
NUMERIC_SCALE BIGINT YES YES
ENUM_VALUES VARCHAR YES YES
COLLATION_NAME VARCHAR NO NO
COLUMN_COMMENT VARCHAR YES YES
SELECT * FROM `data_dictionary` . SHOW_COLUMNS;
Field Type Null Default Default_is_NULL On_Update
|