Purpose of Query
THe query list the attributes without associated category, 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 ca.attrtyp FROM propattr pr JOIN typattr at ON at.attrtyp = pr.attrtyp JOIN catattr ca ON at.attrtyp = ca.attrtyp LEFT JOIN cat c ON c.idcat = ca.idcat WHERE ca.idcat IS NULL
Query result example
--12536
Query result interpretation
The query returns the id of the attribute
Query for Oracle
SELECT ca.attrtyp FROM propattr pr JOIN typattr at ON at.attrtyp = pr.attrtyp JOIN catattr ca ON at.attrtyp = ca.attrtyp LEFT JOIN cat c ON c.idcat = ca.idcat WHERE ca.idcat IS NULL
Query result example
--12536
Query result interpretation
The query returns the id of the attribute
Query for SQL server
SELECT ca.attrtyp FROM propattr pr JOIN typattr at ON at.attrtyp = pr.attrtyp JOIN catattr ca ON at.attrtyp = ca.attrtyp LEFT JOIN cat c ON c.idcat = ca.idcat WHERE ca.idcat IS NULL
Query result example
--12536, 63738
Query result interpretation
The query returns the id of the attribute
Notes/comments
Related Pages