SQL Queries - Common SQL Queries - Queries on metamodel - How to get the list of duplicated metamodel

Purpose of Query

The purpose of this page is to provide queries to detect duplicate metamodel

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server❓
Microsoft SQL Server❓
CSS2✅

 

Query for CSS

Detect the duplicate in the Typ table

SELECT TypNam, TypDsc, Count(1) FROM Typ
group by TypNam, TypDsc
having count(1)>1;

 Detect the duplicate in the Cat table

SELECT CatNam, CatDsc, Count(1) FROM Cat
group by CatNam, CatDsc
having count(1)>1;

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages