Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.37 USER_CONS_COLUMNS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.37 USER_CONS_COLUMNS

The USER_CONS_COLUMNS view provides information about all columns that are included in constraints in tables that are owned by the current user.

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