[thelist] Dropping a view in SQL Server

Joshua OIson joshua at alphashop.net
Tue May 8 09:00:42 CDT 2001

The error is to be expected.  Just trap and ignore the error in whatever
mechanisms the middleware (ASP, CF) provide.


----- Original Message -----
From: "Marios Andreas Tofarides" <matofarides at hotmail.com>
Subject: RE: [thelist] Dropping a view in SQL Server

> >/* 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,
>     Marios

More information about the thelist mailing list