How to get field name types from sql database

Question

To get the field names, you must use the command:

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

My question is, how can I 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 Information

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';

Answer 4

column_name column_type : column_name,      COLUMN_TYPE from information_schema.columns   table_name = 'personal_info';

column_name:

column_name from information_schema.columns   table_name = 'personal_info';

column_type: column_type from information_schema.columns   table_name = 'personal_info';

Answer 5

al shema

SELECT table_name, column_name, column_type FROM information_schema.columns WHERE table_schema = 'shema name'