프로시저소스찾기

프로시저에서 소스찾기

SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%H_HUMAN.FG_PERSON%'
;
 
SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%PHM_POS_GRD_CD%'
AND ROUTINE_TYPE='PROCEDURE'