Search Stored Procedure List with SQL Query Statement

Yogendra Yadav
Feb 05 2016
Code

1.1k
0
0

This code will return list of stored procedure in your database with your keyword(already exists in stored procedure) in stored procedure.

This will display name of stored procedure and code in stored procedure.

SELECT ROUTINE_NAME,ROUTINE_DEFINITION from INFORMATION_SCHEMA.ROUTINES where ROUTINE_DEFINITION like '%y%'