Re: Views question?

Hi Andrew, Thanks for your responded. Our front end Business application is Baan. When we upgrade patches and some tables' definition get change. Baan required us to run their program to reorganize the table. The program is dump the data to file then drop the table then recreated it base on the new definition of the table. That's why the view got deleted every time the table gets dropped. --Wayne "Andrew Hamm" <ahamm@mail.com> wrote in message news:<2jepnoF10edncU1@uni-berlin.de>... > ngte4-inf@yahoo.com wrote: > > > > In informix if I have a table and create a view on it. > > Then I drop the table, does the view also get dropped ? > > Oracle does not drop it - it makes is invalid and can be re-validated. > > > > Is there a setting in informix. > > No. It's never been considered worth the effort to implement I guess. I > expect that the Oracle structure makes it a bit easier to leave abandoned > views hanging around. > > This is is a bit of a nuisance, but > > dbschema -d mydbname -t myviewname > viewname.sql> > is a good way to capture your view's schema. > > By the way, why are you dropping a table and re-creating it? I have seen > that Oracle DBA's seem to drop tables and reload them when you need to alter > it's shape. Is this what you are doing? Informix is very flexible so you > rarely need to drop a table just to add, remove, or change a column. You > don't even have to drop the table if you want to "rebuild it" any more. > > I can't think of any valid reason to drop a table for routine DBA work in > Informix. So.... what's your game plan?

ngte4-inf@yahoo.com wrote: > Hi Andrew, > Thanks for your responded. Our front end Business application is Baan. > When we upgrade patches and some tables' definition get change. Baan > required us to run their program to reorganize the table. The program > is dump the data to file then drop the table then recreated it base on > the new definition of the table. > That's why the view got deleted every time the table gets dropped. Ahhhh Baan - I hear horrible things about it's treatment of the database ;-) I guess you'll have to capture all your view schemas and re-apply manually. Sorry, the lunatics seem to have taken over this thread because they ran out of medication on another thread - NOOOOOO!!!!!! The clown was just being "ironic"