[MS SQL] 查詢所有Procedure

 查詢所有Procedure 

--MS SQL使用
SELECT
name AS ProcedureName,
create_date AS 建立時間,
modify_date AS 異動時間
FROM 
sys.procedures
WHERE 
is_ms_shipped = 0		-- 只顯示使用者自訂的預存程序
ORDER BY ProcedureName;


--通用版本(尚未測試)
SELECT 
ROUTINE_TYPE,
ROUTINE_SCHEMA AS SchemaName,
ROUTINE_NAME AS ProcedureName,
CREATED AS 建立時間,
LAST_ALTERED AS 最後異動時間
FROM 
INFORMATION_SCHEMA.ROUTINES
WHERE 
ROUTINE_TYPE = 'PROCEDURE'	-- 只顯示預存程序
ORDER BY ROUTINE_NAME;

參考網址: 

By Hao★