SQLSERVER批量删除表
declare @name varchar(30)while(exists(select * from sysobjects where name like 'PM%'))beginselect @name=name from sysobjects where name like 'PM%'exec ('drop table '+@name)end
发布时间: 2012-08-02 11:35:26 作者: rapoo
SQLSERVER批量删除表
declare @name varchar(30)while(exists(select * from sysobjects where name like 'PM%'))beginselect @name=name from sysobjects where name like 'PM%'exec ('drop table '+@name)end