/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

10 votes216 views2 answers
Sql rtrim
SQL
1 vote203 views1 answer
Select from describe sql
SQL
15 votes225 views3 answers
Find duplicate keys in mysql
SQL
0 vote231 views1 answer
Sql decimal to 2 places
SQL
16 votes222 views4 answers
Find duplicates mysql
SQL
0 vote235 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote260 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote209 views1 answer
Postgres where
SQL
0 vote235 views1 answer
Java sql insert return id
SQL
0 vote248 views2 answers
Temp tables in sql server
SQL