Friday, 22 March 2024

How to find a particular table or any keyword from all stored procedures of database

We can find it by simple SQL query: -


SELECT name,create_date, modify_date, type

FROM sys.procedures

WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Table_Name_Or_Any_Keyword%'