sql进阶-删除所有的视图
时间：2021-07-01 10:21:17
帮助过：23人阅读
)
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)
sql进阶-删除所有的视图
标签：color from arc and view bsp exe obj name
