/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

0 vote250 views1 answer
Mysql show foreign keys column
SQL
15 votes279 views3 answers
Postgresql change column type
SQL
0 vote290 views1 answer
Insert using condition postgres
SQL
0 vote271 views1 answer
Oracle show grants on table
SQL
0 vote260 views1 answer
Sql delimiter to columns
SQL
0 vote283 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote245 views1 answer
Ms Sql set us timezone
SQL
0 vote276 views1 answer
Close sql query vb.net
SQL
0 vote293 views1 answer
Date 3 months from today sql
SQL
2 votes274 views3 answers
Current setting postgres timezone
SQL