摘要： --视图declare @sql varchar(8000)set @sql= ''select @sql=@sql+ ', '+name from sysobjectswhere type= 'V ' and name not in( 'syssegments ', 'sysconstraints ')set @sql= 'drop view '+stuff(@sql, 1, 1, ' ')exec(@sql)Go--删除存储过程DECLARE @STRING VARCHAR(80 阅读全文