删除所有的视图 存储过程

---------------------删除所有的视图-------------------use fkbmvcultimateGOdeclare @sql varchar(8000)while (select count(*) from sysobjects where type='V')>0beginSELECT @sql='drop view ' + nameFROM sysobjectsWHERE (type = 'V')ORDER BY 'drop view ' + nameexec(@sql) end-------------------删除所有的存储过程-------------------use fkbmvcultimateGOdeclare @sql varchar(8000)while (select count(*) from sysobjects where type='P')>0beginSELECT @sql='drop proc ' + nameFROM sysobjectsWHERE (type = 'P')ORDER BY 'drop table ' + nameexec(@sql) end