Background documentationDROP DBPROC[EDURE] Statement (drop_dbproc_statement) Locate this document in the navigation structure

 

The DROP DBPROC[EDURE] statement (drop_dbproc_statement) deletes a database procedure.

Structure

Syntax Syntax

  1. <drop_dbproc_statement> ::=
      DROP DBPROC[EDURE] <dbproc_name>
End of the code.
Examples

SQL Tutorial, Database Procedures

Explanation

If no schema is specified in the database procedure name, the current schema is assumed implicitly.

The current database user must be the owner of the database procedure or have the DROPIN privilege for the schema to which the database procedure is assigned.

The metadata for the database procedure is deleted.

More Information

Privileges: Overview