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