Check out example codes for "sqlserver: how to search a table used in particular stored procedure". 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