How to compare two databases tables meta data column definitions differences both databases are identical

How to compare two databases tables meta data column definitions differences both databases are identical.

want to check if any differences in columns or db2 table has extra column.

select * from db1.table_orders
compare with
select * from db2.table_orders

Is it posssible, or checking the whole database tables.

Thanks a lot for the helpful info.

you can try Red Gate's schema comparison tool.

If you actually need to see the differences, run the given sample query.

SELECT column_name,ordinal_position,data_type,column_type FROM
(
    SELECT
        column_name,ordinal_position,
        data_type,column_type,COUNT(1) rowcount
    FROM information_schema.columns
    WHERE table_schema=DATABASE()
    AND table_name IN ('product_today','product_yesterday')
    GROUP BY
        column_name,ordinal_position,
        data_type,column_type
    HAVING COUNT(1)=1
) A;

Please go this to know more how to compare the two tables in a database. https://www.simple-talk.com/sql/t-sql-programming/on-comparing-tables-in-sql-server/

Have a look at xSQL Schema Compare. You can use it to compare and then synchronize the schemas