DROP PROCEDURE

Drop one or more stored procedures (or procedure groups) from the current database.

Syntax
      DROP PROCEDURE [schema.]procedure [,...n ];

Key
   procedure     The stored procedure or stored procedure group to be removed.

This command can also be shortened to DROP PROC... 

This command requires that the partition scheme is not currently being used by any tables or indexes.

Examples

DROP PROCEDURE dbo.uspMyProc;
GO

"The best way to get a bad law repealed is to enforce it strictly" - Abraham Lincoln

Related commands

CREATE PROCEDURE
ALTER PROCEDURE
sys.sql_modules - view procedure definition
Equivalent Oracle command: DROP PROCEDURE


 
Copyright © 1999-2024 SS64.com
Some rights reserved