본문 바로가기
개발정보/Database

[MSSQL] 특정 단어가 포함된 프로시저 찾기

by MoelCano 2018. 2. 27.
반응형
 
     SELECT ROUTINE_NAME 
     FROM INFORMATION_SCHEMA.ROUTINES
     WHERE ROUTINE_DEFINITION LIKE '%Search_Text%'
        AND ROUTINE_TYPE='PROCEDURE'
     order by ROUTINE_NAME
 
반응형