This documentation is not maintained. Please refer to doc.castsoftware.com/technologies to find the latest updates.

All Missing tables and procedures extensions are similar. They take as input  SQL queries embedded in client code and generate as output Missing Schemas, Missing Tables, Missing Procedures or Missing SQL TablesMissing SQL Procedures.

From a technical standpoint, SQL queries embedded in client code object types inherit from the metamodel category CAST_SQL_MetricableQuery, generally having icons that look like  

You can also retrieve the full list of SQL queries embedded in client code from the local KB with the following SQL statement : 

List of SQL Queries candidates
select o.KeyNam QueryName, od.InfVal SQLQuery
from ObjDsc od join Keys o on od.IdObj = o.IdKey
     join TypCat tc on tc.IdTyp = o.ObjTyp
where tc.IdCatParent = 139018 -- CAST_SQL_MetricableQuery
      and od.InfTyp = 150 -- sqlQuery property InfTyp = 150, InfSubTyp = 15
      and od.InfSubTyp = 15