mysql tablename search information schema


/ Published in: SQL

search for tables in mysql catalog ( information_schema )


Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.