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

2 votes319 views1 answer
Q operator in sql
SQL
0 vote310 views1 answer
How to declare variable date in mysql
SQL
5 votes311 views4 answers
Rollback to in sql
SQL
10 votes310 views1 answer
User_dependencies
SQL
0 vote306 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote316 views1 answer
Postgresql show owner of database
SQL
0 vote299 views1 answer
Compression of dabatase mysqldumo
SQL
9 votes318 views6 answers
Replace sql
SQL
6 votes293 views1 answer
Postgresql get year
SQL
0 vote297 views2 answers
Postgresql get long running queries
SQL