Getting Information About Procedures

You can get information about the objects referenced by a procedure, display the text of a procedure, or generate a list of ESPs and supporting DLLs.

  • For a report on the objects referenced by a procedure, use sp_depends.

  • To display the text of a create procedure statement, which is stored in syscomments, use sp_helptext with the procedure name as the parameter. You must be using the database where the procedure resides when you use sp_helptext. To display the text of a system procedure, execute sp_helptext from the sybsystemprocs database.

  • To see a list of system extended stored procedures and their supporting DLLs, use sp_helpextendedproc from the sybsystemprocs database.