- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How can we see the list of stored procedures and stored functions in a particular MySQL database?
We can see the list of the stored procedure and stored functions in a particular database by using the following query on INFORMATION_SCHEMA.ROUTINES as follows −
mysql> SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'query'; +--------------+--------------+ | ROUTINE_TYPE | ROUTINE_NAME | +--------------+--------------+ | PROCEDURE | allrecords | | FUNCTION | Hello | +--------------+--------------+ 2 rows in set (0.04 sec)
The above query returns the procedure named ‘allrecords’, and function named ‘Hello’ which are stored in the database named ‘query’.
Published on 21-Feb-2018 07:36:40
- Related Questions & Answers
- How can we see only the list of stored procedures in a particular MySQL database?
- How can we see only the list of stored functions in a particular MySQL database?
- How can we see the list, along with other information, stored procedures in a particular MySQL database?
- How can we see the list, along with complete information, of stored procedures in a particular MySQL database?
- How can we see the list of views stored in a particular MySQL database?
- How can we see the list, along with complete information, of stored functions in a particular MySQL database?
- How can we see the list, along with some other information, of stored functions in a particular MySQL database?
- How can we see the metadata of a view(s) stored in a particular MySQL database?
- How can we see only name and types of the stored routines in a particular MySQL database?
- How can we see the source code of a particular MySQL stored function?
- How can we see the source code of a particular MySQL stored procedure?
- What is stored procedure and how can we create MySQL stored procedures?
- How can we access tables through MySQL stored procedures?
- What are the differences between Stored procedures and functions?
- How can we delete a MySQL stored function from the database?
Advertisements