Count the number of Stored Procedure in a database

Akiii
Posted by Akiii under Sql Server category on | Points: 40 | Views : 934
SELECT COUNT(*) AS PROCEDURE_COUNT 
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'



Select the Database and execute the above code !



Thanks and Regards
Akiii

Comments or Responses

Login to post response