SELECT TABLE_NAME AS Table_Name,
COLUMN_NAME AS Column_Name,
CASE WHEN CHARACTER_MAXIMUM_LENGTH != 'NULL' THEN CONCAT(DATA_TYPE, '(', CHARACTER_MAXIMUM_LENGTH, ')') ELSE DATA_TYPE END AS Data_Types,
CASE WHEN IS_NULLABLE = 'YES' THEN 'NULL' ELSE 'NOT NULL' END AS Default_Expression,
COLUMN_KEY AS Key_Value,
COLUMN_DEFAULT AS Default_Value,
EXTRA AS Auto_Increment
FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='loandb_dev';