List the tables contains same column name in database

list the tables contains same column name in database

Example:

COLUMN NAME uid REPET IN DATABASE TABLES

thank you

SELECT column_name
  FROM information_schema
GROUP
    BY column_name
HAVING COUNT(*) > 1

:slight_smile:

show the tables which contains uid as a column in database

SELECT table_name
  FROM information_schema
 WHERE column_name = 'uid'

are you starting to notice a pattern? :slight_smile:

thank you for your valuable information

this is the query to get the no of tables cotains the same column name in the database is :

SELECT table_name FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = ‘db_name’ and column_name = ‘column_name’