sql search stored procedures for table name code example

Example 1: sqlserver: how to search a table used in particular stored procedure

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

Example 2: search stored procedures by name

select * 
from 
   sys.procedures 
where 
   name like '%name_of_proc%'

Tags:

Sql Example

Related