SELECT TABLE_NAME AS Table_Name,
COLUMN_NAME AS Column_Name,
COLUMN_TYPE 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='customerdb';