Find a text in a Store Procedure or Function

The below code will help us to find out a text in a store procedure/function in a particular database

DECLARE @TextToFind VARCHAR(100) = 'myTable'
SELECT 

		[Object Name] = o.Name

		,[Object Type] = o.Type_Desc

		,[Content In Text Mode] = c.Text

		,[Creation Date] = o.Create_Date

		,[Last Modification Date] = o.Modify_Date

FROM Sys.Objects o
JOIN SysComments c
ON o.object_id = c.id
WHERE o.[Type] IN ('FN','TF','P')
AND c.Text LIKE '%' +@TextToFind + '%'
ORDER BY o.[Type]

Hope this will be helpful