What SQL do I use to get a list of functions and a list of procedures from the database? I need to get two distinct lists. This SQL brings back both procedures and functions in one list:
Thanks, Brad |
Just a backlink from a similar question: Karim has shown a better approach (IMHO) here, based on querying sysprocparm: For each function, that table contains an entry with parm_type = 4 for the function's return type - something that procedure do not have by design. So that should be a reliable way to differentiate them. |