[MSSQL] 프로시져 수정일자 조회

SELECT

    SPECIFIC_NAME

    , ROUTINE_DEFINITION

    , LAST_ALTERED

FROM [테이블명]. INFORMATION_SCHEMA.ROUTINES

WHERE 1=1

AND ROUTINE_TYPE = 'PROCEDURE'

ORDER BY 

    LAST_ALTERED DESC