I am trying to search for dependencies in our database, and I have about 500 stored procedures to go through. Is there an easy way to do this?
I compiled all the show procedures as follows:
SHOW PROCEDURE database_name.procedure_name_1; SHOW PROCEDURE database_name.procedure_name_2; SHOW PROCEDURE database_name.procedure_name_3; SHOW PROCEDURE database_name.procedure_name_4; SHOW PROCEDURE database_name.procedure_name_5; etc
Does anyone know how I can save the result set into a table or export it to a text file where I can perform my searches on the keywords?