Views

I have a db that has several views (virtual tables) set up. How do I find out what the SQL statment is that created the view? Can I edit this or do I have to drop the table and set it up again? Informix version is 7.20.UE2 Regards Martyn

In the year of Our Lord Thu, 15 Feb 2001 12:07:56 -0000, "Martyn Shiner" <nospammartyn.shiner@nospambff-nonwovens.com> spake, saying: >I have a db that has several views (virtual tables) set up. How do I find >out what the SQL statment is that created the view? Can I edit this or do I >have to drop the table and set it up again? dbschema? Drop and recreate.

Martyn Shiner ha scritto nel messaggio <96ggo6$1qm9$1@slrn.eurobell.net>... >I have a db that has several views (virtual tables) set up. How do I find >out what the SQL statment is that created the view? Can I edit this or do I >have to drop the table and set it up again? > >Informix version is 7.20.UE2 > >Regards >Martyn > > > > select a.tabname, b.seqno , b.viewtext from systables a, sysviews b where a.tabid = b.tabid and a.tabid > 99 order by 1, 2 it gives you all your views text; you can filter it by view name flavio gattari

Thanks for that - I'll give it a try Martyn Flavio Gattari <fgattari@datamat.it> wrote in message news:96gqc1$5a7u$1@stargate1.inet.it... > > Martyn Shiner ha scritto nel messaggio <96ggo6$1qm9$1@slrn.eurobell.net>... > >I have a db that has several views (virtual tables) set up. How do I find > >out what the SQL statment is that created the view? Can I edit this or do I > >have to drop the table and set it up again? > > > >Informix version is 7.20.UE2 > > > >Regards > >Martyn > > > > > > > > > > select a.tabname, b.seqno , b.viewtext > from systables a, sysviews b > where a.tabid = b.tabid > and a.tabid > 99 > order by 1, 2> > it gives you all your views text; you can filter it by view name > > flavio gattari > > >