advanced code snippet search

Posted By

ktrout on 01/03/16


Tagged

mysql search InformationSchema


Versions (?)

mysql tablename search information schema

 / Published in: SQL
 

search for tables in mysql catalog ( information_schema )

Expand | Embed | Plain Text 
  1. SELECT table_catalog, table_schema, table_name, table_type, engine
  2. FROM information_schema.TABLES
  3. WHERE table_name LIKE '%digits%'
  4. ;
  5.  
  6. /*
  7. +---------------+--------------+------------+------------+--------+
  8. | table_catalog | table_schema | table_name | table_type | engine |
  9. +---------------+--------------+------------+------------+--------+
  10. | def           | test         | digits_v   | VIEW       | NULL   |
  11. +---------------+--------------+------------+------------+--------+
  12. */

Report this snippet  

You need to login to post a comment.