[thelist] Dropping a view in SQL Server

Marios Andreas Tofarides matofarides at hotmail.com
Tue May 8 08:53:32 CDT 2001

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

Tried it. Got the following message (if the view doesn't exist):
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the view 
'sa.foo', because it doesn't exist in the system catalogs.

Thanks anyway,

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

More information about the thelist mailing list