在查询器中运行 declare @name varchar(20) while(exists(select * from sysobjects where name like 'tb_%')) begin select @name=name from sysobjects where name like 'tb_%' exec ('drop table '+@name) end