home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
EWSQD2CN.QRY
< prev
next >
Wrap
Text File
|
1997-09-11
|
599b
|
28 lines
#NAME#
DA_DB2udbTableColumnName
#DESCRIPTION#
The column name glossary query returns the names of DB2 UDB tables which contain a column which matches the column name specified in the WHERE clause.
View type: DAQDB2csTable
Modifications:
Change the search criteria of the ColumnName attribute in the SQL WHERE clause
#MODIFIED#
#VERSION#
#SQL STATEMENT#
--DA_DB2udbTableColumnName
SELECT
t.db2csTable,
td.tableDefinition,
td.columnName
FROM
DAQDB2csTable t,
(t.usesTableDefinition) td
WHERE
td.columnName like '%'
ORDER BY
t.db2csTable,
td.columnName;