Searching for a specific table name
Here is a way to search the Information_Schema to find all tables that have the letter 't' in them, can be helpful to search the metadata of your database schema
select *
from INFORMATION_SCHEMA.columns
where table_name like '%t%'
order by column_name