[thelist] Dropping a view in SQL Server

[Ron White]

/* Drop views */
if exists (select * from sysobjects where name = 'foo')
drop view sa.foo

Thanks,
Ron White 

<snippage>
Can anyone tell me how can I check whether a view exists, and if it exists 
to drop it. I'm using ASP with SQL Server 7 on a Windows NT Server 4.0. 
</snippage>