Database Reference
In-Depth Information
20.4
Metadata Views
This section simply describes metadata views applicable to constraints.
Chapter 19 describes the basis and detail of Oracle Database metadata
views.
USER_CONSTRAINTS
. Structure of constraints, such as who owns
it, its type, the table it is attached to, and states, among other details.
USER_CONS_COLUMNS
. Describes all columns in constraints.
The script executed in Figure 20.12 matches constraints and constraint
columns for the currently logged-in user. The script is included in Appen-
dix B.
This chapter has dealt with constraints, their states, and adding, modify-
ing, and destroying them. The next chapter looks at indexes.
