SQLserver 实现批量删除表语句declare @name varchar(20) while(exists(select * from sysobjects where n
SQLserver 实现批量删除表语句
declare @name varchar(20) while(exists(select * from sysobjects where name like 'RP_%')) begin select @name=name from sysobjects where name like 'RP_%' exec ('drop table '+@name) end