Breaking News: Grepper is joining You.com. Read the official announcement!

compare table schema in different databases

Drab Dolphin answered on August 11, 2023 Popularity 5/10 Helpfulness 2/10

answer compare table schema in different databases

related compare table schema

compare table schema in different databases

Comment

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='db1' AND table_name='tb1') OR
        (table_schema='db2' AND table_name='tb2')
    )
    AND table_name IN ('product_today','product_yesterday')
    GROUP BY
        column_name,ordinal_position,
        data_type,column_type
    HAVING COUNT(1)=1
) A;

Popularity 5/10 Helpfulness 2/10 Language sql

Source: dba.stackexchange.com

Tags: compare schema sql

Link to this answer
Share Copy Link

Contributed on Aug 11 2023

Drab Dolphin

0 Answers Avg Quality 2/10

Closely Related Answers

compare table schema

Comment

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;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: dba.stackexchange.com

Tags: compare schema sql

Link to this answer
Share Copy Link

Contributed on Aug 11 2023

Drab Dolphin

0 Answers Avg Quality 2/10

compare table schema in different databases

Contents

More Related Answers

compare table schema in different databases

Closely Related Answers

compare table schema

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.