Thanks, Karen. I think that is what I need. James Belisle
Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: 'Karen Tellef' via RBASE-L [mailto:[email protected]] Sent: Monday, March 25, 2019 4:33 PM To: [email protected] Subject: Re: [RBASE-L] - finding views containing certain tables Ever since version 7.0, you no longer need to recreate views when you add columns. You can now create a view like this: as select t1.*, t2.* from table1 t1, table2 t2 where ..... and it doesn't matter if you add columns. But if you want to search views for existence of columns or tables, I do: browse all from sys_views where #2 contains 'whatever' or #3 contains 'whatever' You then have to look up the view name in the sys_tables table Karen -----Original Message----- From: Jim Belisle <[email protected]> To: [email protected] <[email protected]> Sent: Mon, Mar 25, 2019 4:28 pm Subject: [RBASE-L] - finding views containing certain tables How do I find the views that use a specific table? My understanding is if I add a column to a table that is in a view, then I need to recreate the view. So I want to find the views I will need to recreate if I add columns. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. ________________________________ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
