Purpose of Query
This query list the inconsistent association between type and 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 tp.idprop, t.idtyp FROM typprop tp LEFT JOIN typ t ON t.idtyp = tp.idtyp LEFT JOIN prop p ON p.idprop = tp.idprop WHERE t.idtyp IS NULL OR p.idprop IS NULL;
Query result example
--838""
--"";140484;
Query result interpretation
The query returns the Id of the type and the Id of the property
Query for Oracle
SELECT tp.idprop, t.idtyp FROM typprop tp LEFT JOIN typ t ON t.idtyp = tp.idtyp LEFT JOIN prop p ON p.idprop = tp.idprop WHERE t.idtyp IS NULL OR p.idprop IS NULL;
Query result example
--838""
--"";140484;
Query result interpretation
The query returns the Id of the type and the Id of the property
Query for SQL server
SELECT tp.idprop, t.idtyp FROM typprop tp LEFT JOIN typ t ON t.idtyp = tp.idtyp LEFT JOIN prop p ON p.idprop = tp.idprop WHERE t.idtyp IS NULL OR p.idprop IS NULL;
Query result example
--838""
--"";140484;
Query result interpretation
The query returns the Id of the type and the Id of the property
Notes/comments
Related Pages
