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 <!-- #yiv6948934467 _filtered #yiv6948934467 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv6948934467 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv6948934467 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #yiv6948934467 #yiv6948934467 p.yiv6948934467MsoNormal, #yiv6948934467 li.yiv6948934467MsoNormal, #yiv6948934467 div.yiv6948934467MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";} #yiv6948934467 a:link, #yiv6948934467 span.yiv6948934467MsoHyperlink {color:blue;text-decoration:underline;} #yiv6948934467 a:visited, #yiv6948934467 span.yiv6948934467MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv6948934467 p.yiv6948934467MsoAcetate, #yiv6948934467 li.yiv6948934467MsoAcetate, #yiv6948934467 div.yiv6948934467MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";} #yiv6948934467 span.yiv6948934467EmailStyle17 {font-family:"Calibri", "sans-serif";color:windowtext;} #yiv6948934467 span.yiv6948934467BalloonTextChar {font-family:"Tahoma", "sans-serif";} #yiv6948934467 .yiv6948934467MsoChpDefault {} _filtered #yiv6948934467 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv6948934467 div.yiv6948934467WordSection1 {} -->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 -- 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. -- 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.
