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
Ryu
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
Mark brackett
source
to share
try GOLD parser
0
Mladen Prajdic
source
to share