[thelist] Dropping a view in SQL Server
Joshua OIson
joshua at alphashop.net
Tue May 8 06:58:51 CDT 2001
Don't have much time to research this, but check out the sysobjects table.
You can query it just like a regular table. for example,
SELECT *
FROM sysobjects
It contains a record for every object defined in the database. (hopefully)
HTH,
-joshua
----- Original Message -----
From: "Marios Andreas Tofarides" <matofarides at hotmail.com>
Subject: [thelist] Dropping a view in SQL Server
> Hello out there again.
>
> Thanks for the help on the previous problem.
> Can anyone tell me how can I check whether a view exists, and if it exists
> to drop it. I'm using ASP with SQL Server 7 on a Windows NT Server 4.0.
> Thank you
>
> Marios
More information about the thelist
mailing list