Conditional Drop View - Forum - OpenEdge RDBMS - Progress Community

Conditional Drop View


Conditional Drop View

This question is not answered

(Sorry if this isn't the right Forum).

OpenEdge 11.6 - to ease SQL view creation / modification with deployments I've been trying to figure out how to conditionally delete a View IF it exists as not all views are at all clients at any given time (we would like to have a standard script to delete specific views, reload them - and leave any custom views that are at the client alone).

I've tried if (exists (select * from .sysview.. )) and that didn't work (The select on its own works).  

Any help would as always be greatly apreciated.

All Replies