SQL Queries - Common SQL Queries - Corruptions - Corruptions on Metamodel - Get the list of the unused properties

Purpose of Query

The query list the unused properties. 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 p.*
  from Prop p
  left join TypProp tp
   on tp.IdProp = p.IdProp
  left join PropCat pc
   on pc.IdProp = p.IdProp
where tp.IdProp is null
  and pc. IdProp is null;

Query result example

139304;"ejbReferenceName";"Reference Name";137476

Query result interpretation

The query returns the id of the property, the name of the property, the description of the property and the type of the property

Query for Oracle

select p.*
  from Prop p
  left join TypProp tp
   on tp.IdProp = p.IdProp
  left join PropCat pc
   on pc.IdProp = p.IdProp
where tp.IdProp is null
  and pc. IdProp is null;

Query result example

139304;"ejbReferenceName";"Reference Name";137476

Query result interpretation

The query returns the id of the property, the name of the property, the description of the property and the type of the property

Query for SQL server

select p.*
  from Prop p
  left join TypProp tp
   on tp.IdProp = p.IdProp
  left join PropCat pc
   on pc.IdProp = p.IdProp
where tp.IdProp is null
  and pc. IdProp is null;

Query result example

139304;"ejbReferenceName";"Reference Name";137476

Query result interpretation

The query returns the id of the property, the name of the property, the description of the property and the type of the property

Notes/comments

Related Pages