SQL Queries - CAST Knowledge Base - Queries on artifacts - How to get the list of artifacts of the type database

Purpose of Query

The SQL query in this page lists the artifacts of the type - database.

Applicable CAST Version

Release	Yes/No
8.3.x
8.2.x
8.1.x
8.0.x
7.3.x

Applicable RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS2

Query for CSS

SELECT *
FROM   Typ
WHERE  idtyp IN
                 ( SELECT DISTINCT ObjTyp
                 FROM             Keys
                 WHERE            IDKEY IN
                                  ( SELECT object_id
                                  FROM    dssapp_sql_artifacts
                                  )
                 )

Query result example

"idtyp";"typnam";"typdsc";"status"

102;"JV_METHOD";"Java Method";"ACTIVE "
103;"JV_FIELD";"Java Field";"ACTIVE "
138183;"CAST_Oracle_View";"Oracle view";"ACTIVE "
138220;"CAST_Oracle_DML_Trigger";"Oracle dml trigger";"ACTIVE "
138244;"CAST_Oracle_Procedure";"Oracle procedure";"ACTIVE "
138245;"CAST_Oracle_Function";"Oracle function";"ACTIVE "

Query result interpretation

DSSAPP_SQL_ARTIFACTS is filled with databases artifacts (stored procedures, triggers, views, functions...) and other artifacts that use databases artifacts. For instance in the above query results we can see that the types Java Method , Java Field, Oracle view, Oracle dml trigger, Oracle procedure and Oracle function are database types.

Query for Oracle

Same as CSS

Query result example

Same as CSS

Query result interpretation

Same as CSS

Query for SQL server

To be done

Query result example

To be done

Query result interpretation

To be done

Notes/comments

Related Pages