Query contains a A field of all of the table name

Query the database contains the fields a all the name of the table.

Started by Bernie at February 07, 2016 - 2:45 AM

select TABSCHEMA,TABNAME
from SYSCAT.COLUMNS
where COLNAME='a'

Posted by Devin at December 23, 2016 - 12:51 AM

Thank you, and then ask a question, how to check all stored procedures, views, triggers in all fields of a stored procedures, views, triggers.

Posted by Bernie at January 06, 2017 - 1:03 AM

View:
SELECT *
FROM SYSCAT.VIEWS T
WHERE T.TEXT LIKE '%A%'

Posted by Broderick at January 07, 2017 - 2:15 AM

The response to 2013-07-01 16:00:05 was removed by the administrator

Posted by Miriam at January 13, 2017 - 1:22 AM