Export (0) Print
Expand All
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

DROP PROCEDURE (Transact-SQL)

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

Topic link iconTransact-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 ALTER permission on the schema to which the procedure belongs, or CONTROL permission on the procedure.

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

DROP PROCEDURE dbo.uspMyProc;
GO
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.