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

Howdy, Stranger!

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

Categories

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

danielm77danielm77 USAPosts: 72Member

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?

Tagged:

Comments

  • DavidMDavidM USAPosts: 342Member

    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.