SQL Queries - CAST Knowledge Base - Queries on Transactions - How to list the ignored tables by the case insensitive regular expressions

Purpose of Query

This Query list the ignored tables by the case insensitive regular expressions.

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT K.idkey, 
       K.keynam, 
       K.objtyp, 
       L.det_value, 
       L.ret_value, 
       O.fullname 
FROM   keys K, 
       fp_result_objectlist L, 
       objfulnam O 
WHERE  K.idkey = L.object_id 
       AND K.idkey = O.idobj 
       AND NOT EXISTS (SELECT 1 
                       FROM   fp_result_excludedobjects E 
                       WHERE  E.object_id = L.object_id)

Query result example

370;“HW_COMPANY_TYPE”;138017;1;0;“CQCUSER.PARTICIPATING_JEE.HW_COMPANY_TYPE”

Query result interpretation

Notes/comments

Related Pages