Is there Opensource code for parsing SQL Server Proc?

Question

I'm looking at writing a tool for generating code based on the contents of a stored procedure. Like the parameters and stuff.

I was wondering if anybody knew of an open source library that has a all the regex's and stuff to parse all this easily.

Thanks.

Answer 1

try GOLD parser

Answer 2

If the proc is already in Sql Server, and you're just looking for parameter info, you can query INFORMATION_SCHEMA.PARAMETERS. Also, sp_help will show it as the second resultset.