Adaptive Server Enterprise provides system and catalog procedures to carry out many administrative functions and to obtain system information. SAP Sybase IQ supports some of these procedures.
System procedures are built-in stored procedures used for getting reports from and updating system tables. Catalog stored procedures retrieve information from the system tables in tabular form.
sp_helptext 'owner.procedure_name'For all system stored procedures delivered by SAP Sybase, the owner is dbo. To see the text of a stored procedure of the same name owned by a different user, you must specify that user, for example:
sp_helptext 'myname.myprocedure'