declare @name varchar(200)
while(exists(select * from sysobjects where name like ‘表名前缀%‘))
begin
select @name=name from sysobjects where name like ‘表名前缀%‘
exec (‘drop table ‘+@name)
end