A complete personal memorandum when retrieving schema information for a table using JDBC. It is in index order. I will add a description soon
| Column name | Description | Value example |
|---|---|---|
| TABLE_CAT | Database name | database_name |
| TABLE_SCHEM | null | |
| TABLE_NAME | table name | table_name |
| COLUMN_NAME | Column name | id |
| DATA_TYPE | 4 | |
| TYPE_NAME | INT UNSIGNED | |
| COLUMN_SIZE | 10 | |
| BUFFER_LENGTH | 65535 | |
| DECIMAL_DIGITS | null | |
| NUM_PREC_RADIX | 10 | |
| NULLABLE | 0 | |
| REMARKS | Comments on the column | Column comment |
| COLUMN_DEF | null | |
| SQL_DATA_TYPE | 0 | |
| SQL_DATETIME_SUB | 0 | |
| CHAR_OCTET_LENGTH | null | |
| ORDINAL_POSITION | 1 | |
| IS_NULLABLE | NO | |
| SCOPE_CATALOG | null | |
| SCOPE_SCHEMA | null | |
| SCOPE_TABLE | null | |
| SOURCE_DATA_TYPE | null | |
| IS_AUTOINCREMENT | YES | |
| IS_GENERATEDCOLUMN | NO |