CONSTRAINTS COLUMN USAGE

From InterBase

Go Up to System Views


CONSTRAINTS_COLUMN_USAGE identifies columns used by PRIMARY KEY and UNIQUE constraints. For FOREIGN KEY constraints, this view identifies the columns defining the constraint.

CONSTRAINTS_COLUMN_USAGE
Column name Data type Length Description

TABLE_NAME

CHAR

67

Table for which the constraint is defined; nullable

COLUMN_NAME

CHAR

67

Column used in the constraint definition; nullable

CONSTRAINT_NAME

CHAR

67

Unique name for the constraint; nullable

Advance To: