select
table_schema,
table_name,
column_name,
data_type
from information_schema.columns
where
(
table_schema = 'back_office'
and table_name in (
'eps_transaction',
'eps_transaction_source',
'report_conformity_pu_bu_detail'
)
)
or
(
table_schema = 'ourpension'
and table_name in ('eps', 'eps_detail')
)
order by table_schema, table_name, ordinal_position;