/ Published in: SQL

search for tables in mysql catalog ( information_schema )
Expand |
Embed | Plain Text
SELECT table_catalog, table_schema, table_name, table_type, engine FROM information_schema.TABLES WHERE table_name LIKE '%digits%' ; /* +---------------+--------------+------------+------------+--------+ | table_catalog | table_schema | table_name | table_type | engine | +---------------+--------------+------------+------------+--------+ | def | test | digits_v | VIEW | NULL | +---------------+--------------+------------+------------+--------+ */
You need to login to post a comment.