Mysql select table names

Mysql find tables with name

SELECT table_name 
FROM information_schema.tables 
WHERE table_type = 'base table' AND table_name like '%YOUR TABLE NAME%';

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

Mysql select table names

SELECT *
FROM information_schema.tables
WHERE table_type='BASE TABLE'
AND table_schema='<insert_your_database_name_here>'

Source: stackoverflow.com

Similar codes

0 vote145 views1 answer
Cross apply top for each row t1
SQL
0 vote173 views1 answer
Openquery join two tables
SQL
0 vote142 views1 answer
Date diff sql
SQL
7 votes156 views1 answer
Query postgres delete duplicates
SQL
4 votes153 views2 answers
Xampp mysql database server is not starting mac m1
SQL
2 votes163 views1 answer
Docker run postgres locally
SQL
0 vote187 views1 answer
Sql cheetsheet
SQL
7 votes149 views2 answers
Add column table pl sql
SQL
0 vote162 views1 answer
Create tables from xsd to sql server database c#
SQL
1 vote155 views1 answer
Sql exclude duplicates and find even id
SQL