David, Here's a way:
SET VAR vColumnName TEXT = NULL SET VAR vEndKey TEXT = NULL DIALOG 'View column name:' vColumnName vEndKey 1 CAPTION 'Search for columns in VIEWS' select c1.sys_column_name=18 as `Column Name`, t2.sys_table_name=18 as `View Name` c1.sys_type_name=8 as `Data Type`, c1.sys_comment from sys_columns c1, sys_tables t2 where c1.sys_table_id = t2.sys_table_id and t2.sys_table_type = 'view' and c1.sys_column_name like .vColumnName On Fri, Sep 20, 2013 at 10:09 AM, Fitts, David A. <[email protected]>wrote: > Greetings,**** > > ** ** > > When one types LIST COLUMN <columnname> at the R prompt a list of all the > tables that use the column are returned. **** > > ** ** > > Is there some way to do the same for Views ? I would like a list of all > the views that use a particular column. **** > > ** ** > > Thank you,**** > > David Fitts**** > > ** ** >
