On Fri, Sep 20, 2013 at 10:33 AM, Bill Downall <
[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
