Find a column in all tables mysql

Mysql find tables with column name

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

Source: stackoverflow.com

Find a column in all tables mysql

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

Source: stackoverflow.com

Similar codes

10 votes277 views1 answer
Oracle all_dependencies
SQL
1 vote272 views1 answer
Sql server locks
SQL
0 vote295 views1 answer
Set column in all row mysql
SQL
7 votes292 views4 answers
Lowest salary in sql
SQL
0 vote260 views1 answer
Pl sql turn off variable substitution
SQL
0 vote312 views1 answer
Dynamic where clause in sql server stored procedure
SQL
11 votes285 views1 answer
Oracle view ddl
SQL
0 vote269 views1 answer
Sql remove first character from string
SQL
3 votes283 views2 answers
How to modify rows in SQL Server
SQL
0 vote281 views1 answer
Qt qsql check if table exist
SQL