Yes, a trigger would help. The only thing is that I have 200 views.
"Robert Fazio" <dbabob_at_yahoo.nospam.com> wrote in message
news:Xns90FEBCB476C85dbabobyahoocom_at_24.12.106.199...
> "Fayerman" <ilya_at_fayerman.org> wrote in
> news:aHBe7.248$rw3.126752_at_dfiatx1-snr1.gtei.net:
>
> >> By replacing the * with the current column names.
> > I need a dynamic view (select *) due to the changing structure of the
> > tables. Specifying the current columns names would be the opposite of
> > what I wanted.
>
> What we are trying to tell you is that you can't do what you want. The
> closest think that you could do is setup a database trigger and watch for
> changes on that tables structure, then recreate the view.
>
>
> --
> Robert Fazio
> Senior Technical Advisor
> dbabob_at_yahoo.com
Received on Thu Aug 16 2001 - 08:19:17 CDT
