C.29 USER_CONSTRAINTS

USER_CONSTRAINTS data dictionary for Oracle Database Gateway for SQL Server.

Name Type Value

OWNER

VARCHAR2(256)

-

CONSTRAINT_NAME

VARCHAR2(256)

-

CONSTRAINT_TYPE

VARCHAR2(1)

"R" or "P" or "U" or "C"

TABLE_NAME

VARCHAR2(256)

-

SEARCH_CONDITION

VARCHAR2(1)

NULL

R_OWNER

VARCHAR2(256)

-

R_CONSTRAINT_NAME

VARCHAR2(256)

-

DELETE_RULE

VARCHAR2(1)

NULL

STATUS

VARCHAR2(1)

NULL

DEFERRABLE

VARCHAR2(1)

NULL

DEFERRED

VARCHAR2(1)

NULL

VALIDATED

VARCHAR2(1)

NULL

GENERATED

VARCHAR2(1)

NULL

BAD

VARCHAR2(1)

NULL

RELY

VARCHAR2(1)

NULL

LAST_CHANGE

DATE

-