读书人

SQLSERVER批量剔除表

发布时间: 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

读书人网 >SQL Server

热点推荐