[SQL DB] Find table in procedure and find column in Table from DB

 1. find procedure

 SELECT OBJECT_NAME(object_id),  

 OBJECT_DEFINITION(object_id) 

FROM sys.procedures 

WHERE OBJECT_DEFINITION(object_id) LIKE '%Name%'

--change Name between % 

2. Find Column in Table

SELECT T.name AS table_name, C.name AS column_name

FROM   sys.tables AS T

       INNER JOIN sys.columns AS C ON T.object_id = C.object_id

WHERE C.name = 'Column Name' --change 'Column Name' for what you look for