sql server find table by name code example Example: sql server find table name select * from sys.tables where name like '%tablename%'