How do I list all stored procedures in Informix?

sql database stored-procedures informix
CheeseConQueso picture CheeseConQueso · Aug 5, 2011 · Viewed 20.5k times · Source

I'm looking for a way to list all the stored procedures in my database running on Informix.

Is there a table in the "informix".* database that lists stored procedures along with detail information about them?

Answer

Adriano Carneiro picture Adriano Carneiro · Aug 5, 2011

Yes, there is. It's called sysprocedures. Try this to see all there's to see:

select * from sysprocedures

For more information on what detailed information is available, read about sysprocedures and sysprocbody and sysproccolumns.

Related questions

How can I check if a View exists in a Database?

I have some SQL code that needs to be executed if a certain View exists in a database. How would I go about checking if the View exists? EDIT: The DBMS being used is Microsoft SQL Server

Read More
Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS's?

Conventional wisdom states that stored procedures are always faster. So, since they're always faster, use them ALL THE TIME. I am pretty sure this is grounded in some historical context where this was once the case. Now, I'm not advocating …

Read More
Functions vs Stored Procedures

Let's say I have to implement a piece of T-SQL code that must return a table as result. I can implement a table-valued function or else a stored procedure that returns a set of rows. What should I use? In …

Read More