MySQL Forums
Forum List  »  Newbie

Query to find invalid routines on a 5.7.2 database
Posted by: cesar hijar
Date: March 23, 2023 10:17AM

Hi all

Where can I find the STATUS of my procedures and functions belong to my database?
I need to know this through a query.
I found this query but this doesn't have a column describing INVALID or something like that.

FROM information_schema.routines
WHERE routine_schema = 'MYDB'
ORDER BY routine_name;

Please would you send me a query in order to know which routine is INVALID?

thanks in advanced.

Options: ReplyQuote

Written By
Query to find invalid routines on a 5.7.2 database
March 23, 2023 10:17AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.