You can get a report on a stored procedure using sp_help. For example, you can get information on the stored procedure byroyalty, which is part of the pubs2 database, using:
sp_help byroyalty
Name Owner Object_type Create_date -------- ------ ---------------- byroyalty dbo stored procedure Jul 27 2005 4:30PM (1 row affected) Parameter_name Type Length Prec Scale Param_order Mode -------------- ------ ------ ---- ----- ----------- @percentage int 4 NULL NULL 1 (return status = 0)
You can get help on a system procedure by executing sp_help when using the sybsystemprocs database.