Alter View

forum.wishlist (2000-2005) & forum.gupta.wishlist (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 115421
Joined: 24 Feb 2017, 12:00
Location: World wide

Alter View

Post by NewsgroupServer » 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

NewsgroupServer
Robot
Robot
Posts: 115421
Joined: 24 Feb 2017, 12:00
Location: World wide

Alter View

Post by NewsgroupServer » 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 0 guests