Alter View

forum.wishlist (1998-2005) & forum.gupta.wishlist (2005-2010)
Clifford W. Bass

Alter View

Post by Clifford W. Bass » 20 Feb 2007, 17:42

 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

Fridolin Schwarz

Alter View

Post by Fridolin Schwarz » 23 Feb 2007, 13:20

 Posted by:  Fridolin Schwarz 


Even better would be an Oracle-like CREATE OR REPLACE VIEW

fritz

Return to “gupta.wishlist”

Who is online

Users browsing this forum: [Ccbot] and 1 guest