Database Procedures 

Under Procedures, the Catalog Manager displays all the database procedures that were created in the database. You can use SQL Studio to display the definitions of these database procedures, and to delete the database procedures.

Prerequisites

You have the required user authorizations.*

Procedure

·         To display a database procedure, choose Catalog Manager ® Show dbproc Definition.

·         To delete a database procedure, select it and choose Catalog Manager ® Drop dbproc.

*For an explanation of user authorizations and user attributes, see the User Concept section of the documentation The SAP DB Database System.

For information on the syntax of CREATE DBPROC statements, see the CREATE DBPROC Statement section of the Reference Manual: SAP DB.