Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


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 ]


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


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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft