Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.19 DBA_CONS_COLUMNS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.19 DBA_CONS_COLUMNS

The DBA_CONS_COLUMNS view provides information about all columns that are included in constraints that are specified in on all tables in the database.

Name

Type

Description

owner

TEXT

User name of the constraint’s owner.

schema_name

TEXT

Name of the schema in which the constraint belongs.

constraint_name

TEXT

The name of the constraint.

table_name

TEXT

The name of the table to which the constraint belongs.

column_name

TEXT

The name of the column referenced in the constraint.

position

SMALLINT

The position of the column within the object definition.

constraint_def

TEXT

The definition of the constraint.

Previous PageTable Of ContentsNext Page