DB/MySQL

[MySQL] 프로시저 소스, information_schema.ROUTINES

냐옴 2013. 12. 1. 17:24 
프로시저 소스
information_schema.ROUTINES

SELECT *
FROM information_schema.ROUTINES
;

SELECT *
FROM information_schema.ROUTINES
WHERE ROUTINE_TYPE = 'FUNCTION'
;

SELECT *
FROM information_schema.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
;


저작자표시 (새창열림)