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