list the tables contains same column name in database
Example:
COLUMN NAME uid REPET IN DATABASE TABLES
thank you
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
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?
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’