CONSTRAINTCOLUMNS

Definition

The system table CONSTRAINTCOLUMNS contains the columns specified in the CONSTRAINT definitions for the tables for which the current user has privileges.

Structure

CONSTRAINTCOLUMNS

SCHEMANAME

CHAR(32)

Name of the schema

OWNER

CHAR(32)

Name of the owner

TABLENAME

CHAR(32)

Name of table with the CONSTRAINT definition

CONSTRAINTNAME

CHAR(32)

Name of the CONSTRAINT definition

CONSTRAINTTYPE

CHAR(12)

Type of CONSTRAINT definition (CHECK | FOREIGN KEY | KEY | UNIQUE_CONST)

COLUMNNAME

CHAR(32)

Name of the column

COLUMNNO

FIXED(4)

Number of the column within the table or constraint

See also:

SQL Reference Manual, CONSTRAINT Definition (constraint_definition)