Wednesday, 18 April 2018

Query that returns list of all Stored Procedures in an MS SQL database

 

select SPECIFIC_NAME  from dbname.information_schema.routines
 where routine_type = 'PROCEDURE'

No comments:

Post a Comment