Export (0) Print
Expand All
Expand Minimize

DROP PROCEDURE (Transact-SQL)

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

Topic link icon Transact-SQL Syntax Conventions


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

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.

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).

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.

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

DROP PROCEDURE dbo.uspMyProc;
GO

Community Additions

ADD
Show:
© 2014 Microsoft