[thelist] Dropping a view in SQL Server

Ron White ronwhite at members.evolt.org
Tue May 8 07:19:01 CDT 2001

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

Ron White 

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. 

More information about the thelist mailing list