| TABLE_CATALOG |
varchar(64)
|
utf8mb3_tolower_ci
|
|
|
| TABLE_SCHEMA |
varchar(64)
|
utf8mb3_tolower_ci
|
|
|
| TABLE_NAME |
varchar(64)
|
utf8mb3_tolower_ci
|
|
|
| COLUMN_NAME |
varchar(64)
|
utf8mb3_tolower_ci
|
|
|
| ORDINAL_POSITION |
int
|
|
|
|
| COLUMN_DEFAULT |
text
|
utf8mb3_bin
|
|
|
| IS_NULLABLE |
varchar(3)
|
utf8mb3_general_ci
|
|
|
| DATA_TYPE |
longtext
|
utf8mb3_bin
|
|
|
| CHARACTER_MAXIMUM_LENGTH |
bigint
|
|
|
|
| CHARACTER_OCTET_LENGTH |
bigint
|
|
|
|
| NUMERIC_PRECISION |
bigint
|
|
|
|
| NUMERIC_SCALE |
bigint
|
|
|
|
| DATETIME_PRECISION |
int
|
|
|
|
| CHARACTER_SET_NAME |
varchar(64)
|
utf8mb3_general_ci
|
|
|
| COLLATION_NAME |
varchar(64)
|
utf8mb3_general_ci
|
|
 Parcourir les valeurs étrangères
|
| COLUMN_TYPE |
mediumtext
|
utf8mb3_bin
|
|
|
| COLUMN_KEY |
enum('', 'PRI', 'UNI', 'MUL')
|
utf8mb3_bin
|
|
|
| EXTRA |
varchar(256)
|
utf8mb3_general_ci
|
|
|
| PRIVILEGES |
varchar(154)
|
utf8mb3_general_ci
|
|
|
| COLUMN_COMMENT |
text
|
utf8mb3_bin
|
|
|
| GENERATION_EXPRESSION |
longtext
|
utf8mb3_bin
|
|
|
| SRS_ID |
int
|
|
|
|
