[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,
Marios
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
More information about the thelist
mailing list