select
table_name,
column_name,
data_type,
udt_name,
is_nullable,
column_default
from information_schema.columns
where table_schema = 'ourpension'
and table_name in (
'spr_indicator_bu',
'spr_accounts_indicator_bu'
)
order by table_name, ordinal_position;