Click here to Skip to main content
15,075,638 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
i need a query to get the table name, functions, views and nested stored procedure used inside one stored procedure.
Posted
Comments
GuyThiebaut 20-Nov-13 6:59am
   
As far as I know this is not possible without parsing the stored procedure i.e. writing code to analyse each line of the stored procedure.

The only meta data relating to a stored procedure that is available are the parameters which can be accessed via reflection.

1 solution

   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900