* 참고 출처 : http://jwoojeong.tistory.com/entry/%ED%8A%B9%EC%A0%95-%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84-%EC%82%AC%EC%9A%A9%ED%95%98%EB%8A%94-STORED-PROCEDURE-%EC%B0%BE%EA%B8%B0
SELECT DISTINCT O.name AS Function_Name
FROM SYSDEPENDS AS D INNER JOIN SYSOBJECTS AS O
ON D.id = O.id
WHERE O.xtype = 'P'
AND D.depid = (SELECT id FROM SYSOBJECTS
WHERE name = 'A_Table')
댓글 없음:
댓글 쓰기