如何获取MySQL数据库中存储过程的总数?我需要在信息模式中查找吗?
SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE="PROCEDURE"
AND ROUTINE_SCHEMA="dbname";
SELECT count(ROUTINE_NAME)procedure_count
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE="PROCEDURE"
AND ROUTINE_SCHEMA="your database name";
这对我有用
SELECT
COUNT(*) as 'Stored Procedures'
FROM SYS.OBJECTS
WHERE TYPE ='P'
GROUP BY TYPE
INFORMATION_SCHEMA
。具体来说,可以参考这个答案。 - Mahesh