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 | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/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