Useful Queries

The following queries may be useful as written, or they can be used as the starting point for developing a query of your own.

This section contains the following topics:

Logical and Physical Names for all Entities

Names of Logical Entities

Qualified Names for Physical Entities (Tables)

Definitions for All Entities

Logical and Physical Names of Attributes

Attributes with Data Types

Logical-Only Attributes

Logical-Only and Physical-Only Status of Attributes

Domain Usage

Domains Not Used by Attributes

Key Group Types

Subject Area Membership

Model UDP Definitions

Objects Using a Default Name

Non-Subtype Relationships

All Objects Created During a Modeling Session

All Objects Deleted During a Modeling Session

All Objects Modified During a Modeling Session

All Objects and Properties Modified During a Modeling Session

Entities Not Having Primary Key Columns

Migrated Physical Attributes

Oracle Model Object Types