[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.

-joshua

----- 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