sql进阶-删除所有的视图
标签：color from arc and view bsp exe obj name
sql进阶-删除所有的视图
)
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)