Icon DROP PROCEDURE

Drops an existing procedure.

Syntax
DROP PROCEDURE <Name>

Usage
Use this statement to drop a procedure from a database.

Warning Dropping a procedure can cause other jobs, functions, procedures, and triggers to generate an error if they refer to the procedure being dropped.

Examples
-- The following statement drops the UpdateState procedure.

DROP PROCEDURE "UpdateState"

Required Privileges
The current user must be granted the DROP privilege on the current database in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
RESTRICT and CASCADEElevateDB does not support the RESTRICT or CASCADE clauses.
Image