---

select
    column_name,
    data_type
from information_schema.columns
where table_schema = 'ourpension'
  and table_name = 'contract'
  and column_name like '%type%'
order by column_name;