Getting Stored Procedure Information from .Net
- by Ben
Hi,
I am trying to get some data relevant to a stored procedure (or funtion) back from a database using .Net.
The first thing I need to be able to do, is get the stored proc from the database and turn it into string format.
The information I need is: The return set of columns, tables used within the SP, Stored Procedures called from the SP. The only way of doing this at the moment that i can think of, is though parsing the text and looking for keyword matches. Is there a better way of doing this?
Any ideas?
Thanks.