USER_CONSTRAINTS

Previous Next JavaScript must be enabled to correctly display this content

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`	-

Parent topic: Data Dictionary