Clever Geek Handbook

Is there any Opensource code for parsing SQL Server Proc?

I am looking to write a tool to generate code based on the contents of a stored procedure. Like parameters and stuff.

I was wondering if anyone from an open source library knows that has all the regex and stuff to easily parse the whole thing.

Thank.

+1


source to share


2 answers


If the proc is already on Sql Server and you are just looking for information about the parameters, you can query INFORMATION_SCHEMA.PARAMETERS . In addition, sp_help will show it as the second result set.



0


source


try GOLD parser



0


source






More articles:


All Articles