/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 vote130 views1 answer
Oracle last connexion
SQL
0 vote119 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote124 views1 answer
Sql server isnull function nor working count
SQL
0 vote104 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
1 vote140 views1 answer
Limit offset order by mysql
SQL
0 vote116 views1 answer
Select only one row sql
SQL
5 votes121 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote138 views1 answer
Sqlalchemy query join many to many
SQL
1 vote113 views1 answer
Wherein mysql
SQL
0 vote120 views2 answers
2nd max salary query in sql
SQL