Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.2 ALL_CONS_COLUMNS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.2 ALL_CONS_COLUMNS

The ALL_CONS_COLUMNS view provides information about the columns specified in constraints placed on tables accessible 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