[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