Thanks Bill, works like a charm. Dave Fitts From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Friday, September 20, 2013 10:37 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Listing columns used in views
On Fri, Sep 20, 2013 at 10:33 AM, Bill Downall <[email protected]<mailto:[email protected]>> wrote: 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 Sorry, meant to clean it up in email before I pushed "SEND": 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
