DROP DBPROC[EDURE] Statement (drop_dbproc_statement)

				
<drop_dbproc_statement>::=
  DROP DBPROC[EDURE] <dbproc_name>
				
			

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.