---

select
    table_schema,
    table_name,
    column_name,
    data_type
from information_schema.columns
where table_schema = 'prod_line'
  and (
       lower(column_name) like '%guarant%'
    or lower(column_name) like '%replen%'
    or lower(column_name) like '%warranty%'
  )
order by table_name, column_name;