search table by name sql server code example

Example 1: sql server find table name

select * from sys.tables where name like '%tablename%'

Example 2: get all tables using like

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