/SQL/Get table which have specific columns in mysql

Get table which have specific columns in mysql

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

Source: stackoverflow.com

Similar codes

8 votes387 views3 answers
Postgres database sizes
SQL
2 votes331 views1 answer
Match in sql server
SQL
3 votes331 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote375 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote350 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote325 views1 answer
Stuff in sql server
SQL
1 vote354 views1 answer
Error code 1292 mysql workbench
SQL
0 vote342 views1 answer
Learn sqlite dart
SQL
1 vote363 views1 answer
How to fetch alternate records from two tables
SQL
0 vote346 views1 answer
Get foreign table names mysql
SQL