如何删掉一个库里的所有视图

[longsql]

请问各位老大，我想删掉一个数据库的所有视图，怎么写语句呢，谢谢各位！

[tim_spac]

declare @vw_name varchar(128)
declare @sql varchar(512)

declare cur_views cursor for
select name from dbo.sysobjects where type=N'V' and category=0
open cur_views
fetch next from cur_views into @vw_name
while @@fetch_status!=-1 begin
  set @sql = 'drop view '''+@vw_name+''''
  exec @sql
fetch next from cur_views into @vw_name
end
close cur_views
deallocate cur_views

[liangCK]

declare @viewname sysname
declare cur cursor for
select name from sysobjects where xtype='V'
open cur
fetch next from cur into @viewname
while @@fetch_status=0
begin
exec ('drop view '+@viewname)
fetch next from cur into @viewname
end
close cur
deallocate cur