1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
/*이름 , 종류, 어떻게 작성되어있는지까지 한번에 확인가능*/
 
 
select * from INFORMATION_SCHEMA.ROUTINES
where ROUTINE_TYPE = 'PROCEDURE'
 
 
 
 
 
select * from INFORMATION_SCHEMA.ROUTINES
where ROUTINE_TYPE = 'FUNCTION'
 
 
 
cs


Posted by 요지
,