--批量删除表 declare @sql varchar(8000),@tbname varchar(400) select @sql='',@tbname = '%test%'--这里写你希望批量删除的表的特征,此处只要表名中有test就都删除 select @sql = @sql+' drop table '+name from sysobjects a where xtype='U' and name like @tbname exec(@sql)
改一下specialsoldier(雪地撒野~噢姐姐,我要回家) ( ) 信誉:100 Blog 代码。declare @sql varchar(8000),@tbname varchar(400) select @sql='',@tbname = '%test%'--这里写你希望批量删除的表的特征,此处只要表名中有test就都删除 select @sql = 'select '+' drop table '+name from sysobjects a where xtype='U' and name like @tbname exec(@sql)
晕,看错了,不好意思, select 'drop table '+name form sysobjects a where xtype='u' and name like '%条件%' 如果放在EXEC里 'select ''drop table''+name from sysobjects where xtype=''u'' and name like ''%条件%'''
declare @sql varchar(8000),@tbname varchar(400)
select @sql='',@tbname = '%test%'--这里写你希望批量删除的表的特征,此处只要表名中有test就都删除
select @sql = @sql+' drop table '+name
from sysobjects a
where xtype='U' and name like @tbname
exec(@sql)
在系统表sysobjects保存有所在数据库中各个对象的信息(包括表),可以参考一下
代码。declare @sql varchar(8000),@tbname varchar(400)
select @sql='',@tbname = '%test%'--这里写你希望批量删除的表的特征,此处只要表名中有test就都删除
select @sql = 'select '+' drop table '+name
from sysobjects a
where xtype='U' and name like @tbname
exec(@sql)
select 'drop table '+name form sysobjects a where xtype='u' and name like '%条件%'
如果放在EXEC里
'select ''drop table''+name from sysobjects where xtype=''u'' and name like ''%条件%'''
狠!!
不过不如
Formart C: