sql - 按名称删除一组存储过程

Question

我有一组名称类似于“somename_%”的存储过程。有没有办法用一个查询删除那个 SP，例如

DROP PROCEDURE where name like 'somename_%'

.

Answer 1

这适用于 MSSQL 2005 +

DECLARE @DropScript varchar(max)
set @DropScript = ''

SELECT @DropScript = @DropScript + 'DROP PROCEDURE [' + schema_name(schema_id)+ '].' + '[' + name + ']
' FROM sys.procedures
where name like 'somename_%'


exec (@DropScript)