Database Knowledge Base / MySQL /
Add comment
Name:
Email:
* Comment:
(Use BBcode - No HTML)
code
* Confirmation code:   Write the characters in the image above exactly as you see it


Is there a way to view all Stored Procedures in a database?
Yes, using the INFORMATION_SCHEMA.ROUTINES table: SELECT ROUTINE_TYPE,ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='dbname'; See also http://dev.mysql.com/doc/mysql/en/routines-table.html


RSS
Powered by DBNest.com (Nest of DB Professionals)