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
SQL 批量删除数据表
原文：http://www.cnblogs.com/allen0118/p/3946306.html
