Displaying Procedure Information

Use sp_iqprocedure to show information about system and user-defined procedures in a database.

In Interactive SQL, run sp_iqprocedure.
Displays information about the user-defined procedure sp_test:
sp_iqprocedure sp_test

proc_name    proc_owner    proc_defn       replicate     srvid     remarks

sp_test      DBA        create procedure   N             (NULL)    (NULL)
                        DBA.sp_test(in n1
                        integer)
                        begin message‘sp_test’end
Parent topic: Procedures