how to find table table in stored procedure sql server 1

how to find table table in stored procedure sql server

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

Here is what the above code is Doing:
1. It’s looking for all procedures that have the word “TableNameOrWhatever” in them.
2. It’s returning the name of the procedure.

Similar Posts