SQL Queries - Common SQL Queries - Corruptions - Corruptions on Metamodel - Get the list of the attributes without associated property

Purpose of Query

The query list the attributes without associated property. You can run the query on central and local schema.

Applicable CAST Version

Release	Yes/No
8.3.x
8.2.x
8.1.x
8.0.x

Applicable RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS2

Query for CSS

SELECT pr.attrtyp, pr.attrtyp
FROM   propattr pr 
       JOIN typattr at 
         ON at.attrtyp = pr.attrtyp 
       JOIN catattr ca 
         ON at.attrtyp = ca.attrtyp 
       LEFT JOIN prop p 
              ON pr.idprop = p.idprop 
WHERE  pr.idprop IS NULL

Query result example

--67585

Query result interpretation

The query returns the id of the attribute

Query for Oracle

SELECT pr.attrtyp, pr.attrtyp
FROM   propattr pr 
       JOIN typattr at 
         ON at.attrtyp = pr.attrtyp 
       JOIN catattr ca 
         ON at.attrtyp = ca.attrtyp 
       LEFT JOIN prop p 
              ON pr.idprop = p.idprop 
WHERE  pr.idprop IS NULL

Query result example

--67585

Query result interpretation

The query returns the id of the attribute

Query for SQL server

SELECT pr.attrtyp , pr.attrtyp
FROM   propattr pr 
       JOIN typattr at 
         ON at.attrtyp = pr.attrtyp 
       JOIN catattr ca 
         ON at.attrtyp = ca.attrtyp 
       LEFT JOIN prop p 
              ON pr.idprop = p.idprop 
WHERE  pr.idprop IS NULL

Query result example

--67585

Query result interpretation

The query returns the id of the attribute

Notes/comments

Related Pages