DROP PROCEDURE (Transact-SQL)
Removes one or more stored procedures or procedure groups from the current database.
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).
The following example removes the dbo.uspMyProc stored procedure in the current database.
DROP PROCEDURE dbo.uspMyProc; GO