Progamming/MSSQL
[MSSQL]특정 테이블이나 구문이 들어간 프로시저 찾는 방법
BIBIA
2020. 10. 26. 13:29
SELECT DISTINCT B.NAME
FROM SYS.SYSCOMMENTS A
LEFT OUTER JOIN SYS.OBJECTS B
ON A.ID= B.OBJECT_ID
WHERE A.TEXT LIKE '%'+''+'%'
혹은
SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%찾을 문자%'
AND ROUTINE_TYPE='PROCEDURE'
order by ROUTINE_NAME