22,209
社区成员
发帖
与我相关
我的任务
分享
declare @sql varchar(8000)/*删除所有视图*/
set @sql=''
select @sql=@sql+ ', '+name from sysobjects
where type= 'V ' and name not in( 'syssegments ', 'sysconstraints ')
set @sql= 'drop view '+stuff(@sql, 1, 1, ' ')
exec(@sql)
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+ ', '+name from sysobjects
where type IN('FN','IF','TF')
set @sql= 'drop FUNCTION '+stuff(@sql, 1, 1, ' ')
PRINT @sql
--exec(@sql)--觉得没问题再反注释该句
declare @sql varchar(8000)/*删除所有Function*/
set @sql=''
select @sql=@sql+ ', '+name from sysobjects
where type= 'FN ' and name not in( 'syssegments ', 'sysconstraints ')
set @sql= 'drop function '+stuff(@sql, 1, 1, ' ')
select @sql
exec(@sql)