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

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

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.