What is the select to get the list of stored procedures and their parameter
Hi;
We need to pull all stored procedures and their parameters from a database's metadata. What is the select to do this?
For each stored procedure we need:
1. scheam
2. name
3. description (not critical)
4. is it a system or user SP
5. return type (not critical)
6. The parameters (see below)
And for each parameter:
1. name
2. data type
3. direction (in, out, etc)
4. Does it have a default (not critical).
Any suggestions on how to pull this info? We are accessing the database via an ADO.NET connector.
thanks - dave