Query to find out list of all the procedure using specific table.

Posted by Virendradugar under Sql Server category on | Views : 3021
Below query will give listing of all the procedures in your database which are using table "Users"

Select SPECIFIC_NAME from information_Schema.Routines where Routine_Definition like '%Users%' 

You just need to replace the name of table as per your requirement.

Really worth.

Comments or Responses

Login to post response