Query to get field name with datatype and size

Query to get field name with datatype and size

SELECT column_name as 'Column Name', data_type as 'Data Type', 

character_maximum_length as 'Max Length' 

FROM information_schema.columns 

FROM information_schema.columns