Posted by: Clifford W. Bass
Hello,
My wish for today is the ability to alter the selection part of a view.
That is, the part that follows the "as" keyword.
Currently, to make a change like that you have to drop the view and
recreate it anew. This proved to be a pain yesterday when the view whose
selection criteria I needed to change was used with fourteen other views.
After dropping and recreating the base view, I then had to recreate all of
the other views, restore all the "table" and column authorizations, recreate
all the synonyms, and restore all of the comments on them.
Thank You,
Clifford Bass