Information_schema.tables does not show all tables


I attempted to query all tables containing a certain keyword with

SELECT * FROM information_schema.tables WHERE table_name LIKE '%foo%;

This returns a list of tables much smaller than I know it should be (but the returned results are correct). Does anyone know what this issue could be caused by?

Hello @sector373,

What is the actual and expected output you are looking forward to?

Your query would return all the table names having foo in their name.