how to get field name types from a sql database

Question

To get field names one would use the command:

select column_name from information_schema.columns where table_name='person'; 

My question is how would one also get the field types in a similar list?

Answer 1

SELECT
    column_name,
    column_type    # or data_type 
FROM information_schema.columns 
WHERE table_name='person'; 

Schema Info