SQL Queries - CAST Knowledge Base - Queries on Links - How to count the number of links having a table as callee

Purpose of Query

The query retrieves the number of links having a table as callee.

Applicable CAST Version

ReleaseYes/No
8.3.x✅

Applicable RDBMS

RDBMSYes/No
CSS✅

Query for CSS

SELECT Count (*) 
FROM   acc a, 
       (SELECT idkey 
        FROM   keys 
        WHERE  objtyp IN ( 139003, 1, 3, 4, 
                           6, 9, 10, 12, 
                           15, 17, 18, 529, 
                           954, 106000, 22, 278, 
                           301, 302, 303, 304, 
                           358, 107000 )) ServerObjects 
WHERE  a.idcle = ServerObjects.idkey

Query result example

0

Query result interpretation

The number of links having a table as callee is 0

Notes/comments

Related Pages