• Article

DROP PROCEDURE (Transact-SQL)

Removes one or more stored procedures or procedure groups from the current database.

Topic link iconTransact-SQL Syntax Conventions

Syntax

DROP { PROC | PROCEDURE } { [ schema_name. ] procedure } [ ,...n ]

Arguments

  • schema_name
    Is the name of the schema to which the procedure belongs. A server name or database name cannot be specified.

  • procedure
    Is name of the stored procedure or stored procedure group to be removed. Procedure names must follow the rules for identifiers.

Remarks

To see a list of procedure names, use the sys.objects catalog view. To display the procedure definition, use the sys.sql_modules catalog view. When a stored procedure is dropped, information about the procedure is removed from the sys.objects and sys.sql_modules catalog views.

Individual procedures within a group of numbered procedures cannot be dropped; the whole procedure group is dropped. For more information about grouped procedures, see CREATE PROCEDURE (Transact-SQL).

Permissions

Requires CONTROL permission on the procedure, or ALTER permission on the schema to which the procedure belongs, or membership in the db_ddladmin fixed server role.

Examples

The following example removes the dbo.uspMyProc stored procedure in the current database.

DROP PROCEDURE dbo.uspMyProc;
GO