Return to Snippet

Revision: 70282
at January 3, 2016 13:32 by ktrout


Initial Code
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   |
+---------------+--------------+------------+------------+--------+
*/

Initial URL


Initial Description
search for tables in mysql catalog ( information_schema )

Initial Title
mysql tablename search information schema

Initial Tags
mysql, search

Initial Language
SQL