| Subject | DLL Scripting | 
|---|---|
| Author | zifnabbe | 
| Post date | 2004-11-24T14:06:40Z | 
I would like to update some of my users databases through a script. 
Some databases contain certain views which need to be updated. For
this I first DROP the view and then CREATE it again.
However, this gives a problem for the databases in which the VIEW
doesn't exist yet. Is there a way to detect if a VIEW (or TABLE, ...)
exists in a database and according to that result exutete the DROP
DLL-statement?
Thanks
            Some databases contain certain views which need to be updated. For
this I first DROP the view and then CREATE it again.
However, this gives a problem for the databases in which the VIEW
doesn't exist yet. Is there a way to detect if a VIEW (or TABLE, ...)
exists in a database and according to that result exutete the DROP
DLL-statement?
Thanks