SQL Server search table in DataBase

select * from information_schema.tables where table_name like '%table_name%'