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