Check if two tables have the same columns

query.sql

--Check different columns
select znew.column_name as newcol,
       zold.column_name as oldcol
from (
select column_name
from information_schema.columns
where table_schema = 'zendesk'
       and table_name = '_groups') zold
    full join
        (select column_name
         from information_schema.columns
         where table_schema = 'zendesk_new'
             and table_name = 'group') znew on znew.column_name = zold.column_name;