How to get the names of the tables having the same column name in MySQL?

There are few column names in many of my tables of my database. I need to list all the tables having these common columns. How can I achieve this?

Comments

  • This is an extracted solution from another thread.

    To get all tables with columns 'columnA' or 'ColumnB' in the database 'YourDatabase'

    SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
    AND TABLE_SCHEMA='YourDatabase';
    
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion