MySQL Stored Procedure Function Information How to Find

MySQL Example - Stored Procedure Function Information How to Find in MySQL

Open your MySQL Query Editor then copy & paste the below code to get Stored Procedure & Function Information in MySQL:

   SELECT ROUTINE_NAME, ROUTINE_TYPE
   FROM information_schema.ROUTINES
   WHERE ROUTINE_SCHEMA = 'sp'
   Note that:
   'sp' is the SCHEMA/Database name
   'ROUTINE_NAME' is the Object name
   'ROUTINE_TYPE' is the type of the Object : Procedure or Function

MySQL Example - Stored Procedure Function Information How to Find in MySQL - MySQL Query Editor Output

No comments:

Post a Comment

leave your comments here..