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
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server (question)
Microsoft SQL Server (question)
CSS2 (tick)

 

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