Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.3 ALL_CONSTRAINTS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.3 ALL_CONSTRAINTS

The ALL_CONSTRAINTS view provides information about the 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.

constraint_type

TEXT

The constraint type. Possible values are:

      C – check constraint

      F – foreign key constraint

      P – primary key constraint

      U – unique key constraint

      R – referential integrity constraint

      V – constraint on a view

      O – with read-only, on a view

table_name

TEXT

Name of the table to which the constraint belongs.

search_condition

TEXT

Search condition that applies to a check constraint.

r_owner

TEXT

Owner of a table referenced by a referential constraint.

r_constraint_name

TEXT

Name of the constraint definition for a referenced table.

delete_rule

TEXT

The delete rule for a referential constraint. Possible values are:

      C – cascade

      R – restrict

      N – no action

deferrable

BOOLEAN

Specified if the constraint is deferrable (Y or N).

deferred

BOOLEAN

Specifies if the constraint has been deferred (Y or N).

index_owner

TEXT

User name of the index owner.

index_name

TEXT

The name of the index.

constraint_def

TEXT

The definition of the constraint.

Previous PageTable Of ContentsNext Page