How to get the list of stored procedure ?

  • Thread starter Thread starter Lloyd Dupont
  • Start date Start date
L

Lloyd Dupont

Basically I have a SqlConnection and I would like to be able to
automatically fetch a list of stored procedure in the server and be able to
cull out all which have parameters (I need the list of parameterless
procedures)

anyway or clues on how to do that ?
 
Hi Lloyd,

Try the following selects:

select * from INFORMATION_SCHEMA.ROUTINES
select * from INFORMATION_SCHEMA.PARAMETERS
 
great ! thanks ;-)

Miha Markic said:
Hi Lloyd,

Try the following selects:

select * from INFORMATION_SCHEMA.ROUTINES
select * from INFORMATION_SCHEMA.PARAMETERS
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adobe "Wrong type parameter supplied to a PDS procedure" 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
Programatically call extended stored procedure? 2
Running stored procedure that has default values 2
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Passing parameter to store SQL procedure ??? 2
Creating Stored Procedure 5
calling a stored procedure in ADO.NET 2.0 12

Back
Top