按名称删除一组存储过程 [英] Drop group of stored procedures by name

问题描述

我有一组名称类似于somename_%"的存储过程.有什么办法可以通过一个查询删除那个 SP，例如

I have group of stored procedures with names like 'somename_%'. Are there any way to delete that SP with one query, forexample

DROP PROCEDURE，其中名称为'somename_%'

DROP PROCEDURE where name like 'somename_%'

.

推荐答案

这适用于 MSSQL 2005 +

This works for 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)

这篇关于按名称删除一组存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！