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

Answer 2

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

Answer 3

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