Check out example codes for "how to search table name in stored procedure in sql server". It will help you in understanding the concepts better.

Code Example 1

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%TableNameOrWhatever%'

Learn ReactJs, React Native from akashmittal.com