Filter or Search SQL table using SQL Query

In this article, I will explain how to filter table with containing text in SQL server database using SQL query.  

To filter all table which contains given text in SQL server we need to write query using SYS.TABLES table.

SQL Query :

DECLARE @Parameter VARCHAR(100)      

SET @Parameter = 'employee'

SELECT * FROM SYS.TABLES      

WHERE NAME LIKE '%'+ @PARAMETER +'%'      

ORDER BY MODIFY_DATE DESC