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