---

select
    column_name,
    data_type
from information_schema.columns
where table_schema = 'ourpension'
  and table_name = 'agent'
order by ordinal_position;