/SQL/Mysql search for column name in all tables

Mysql search for column name in all tables

SELECT DISTINCT TABLE_NAME, COLUMN_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%partial_column_name%'
    AND TABLE_SCHEMA='YourDatabase';

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

Similar codes

0 vote234 views1 answer
Sqlite3 not commit
SQL
-1 vote195 views5 answers
Online sql to linq generator
SQL
5 votes214 views1 answer
Oracle asynchronous query
SQL
3 votes196 views2 answers
How to start postgresql on windows
SQL
8 votes270 views1 answer
Oracle search code in packages
SQL
13 votes218 views2 answers
Oracle inner join
SQL
6 votes205 views3 answers
Mysql server is not starting xampp
SQL
0 vote201 views1 answer
Prodection ready postgres database step by step
SQL
2 votes180 views1 answer
Get first 2 letter in sql
SQL
1 vote172 views1 answer
Real world example of nosql
SQL