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