使用一段代码删除SQL SERVER数据库所有表:
declare @tname varchar(8000) set @tname='' select @tname=@tname + '[' + Name + '],' from sysobjects where xtype='U' select @tname='drop table ' + left(@tname,len(@tname)-1) exec(@tname)
发布时间:2017-04-19
使用一段代码删除SQL SERVER数据库所有表:
declare @tname varchar(8000) set @tname='' select @tname=@tname + '[' + Name + '],' from sysobjects where xtype='U' select @tname='drop table ' + left(@tname,len(@tname)-1) exec(@tname)