• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Retrieve Stored Procedure Code

 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a way to retrieve the actual sql code from a stored procedure in MySQL. Also, is there a way to get the names of all the stored procedures in a database without knowing them?
 
Dave Vick
Ranch Hand
Posts: 3244
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Gregg
Check out the getProcedures method of the DatabaseMetaData class. It lloks like ti might return the actual code too.
hope that is what you were looking for.
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dave my savior. Thank you very much.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic