search db for table name code example

Example: search db for table name

SELECT * 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME LIKE '%whatever%'