Is there any feature to drop the view with out cascading the dependents.
Below is my requirement.
I have a view which is dependent on the other view/table. I wanted to drop the view dynamically and recreate the view with same name ( definition of view will differ ) with out cascading its dependents, after that I created the view it should have its dependents as to that of older one.