[Home] [Help] [Dependency Information]
Object Name: | INT$DBA_CONSTRAINTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
CONSTRAINT_NAME | VARCHAR2 | (128) | Yes | |
CONSTRAINT_TYPE | VARCHAR2 | (1) | ||
TABLE_NAME | VARCHAR2 | (128) | Yes | |
OBJECT_ID | NUMBER | Yes | ||
OBJECT_TYPE# | NUMBER | Yes | ||
SEARCH_CONDITION | LONG | (0) | ||
SEARCH_CONDITION_VC | VARCHAR2 | (4000) | ||
R_OWNER | VARCHAR2 | (128) | ||
R_CONSTRAINT_NAME | VARCHAR2 | (128) | ||
DELETE_RULE | VARCHAR2 | (9) | ||
STATUS | VARCHAR2 | (8) | ||
DEFERRABLE | VARCHAR2 | (14) | ||
DEFERRED | VARCHAR2 | (9) | ||
VALIDATED | VARCHAR2 | (13) | ||
GENERATED | VARCHAR2 | (14) | ||
BAD | VARCHAR2 | (3) | ||
RELY | VARCHAR2 | (4) | ||
LAST_CHANGE | DATE | |||
INDEX_OWNER | VARCHAR2 | (128) | ||
INDEX_NAME | VARCHAR2 | (128) | ||
INVALID | VARCHAR2 | (7) | ||
VIEW_RELATED | VARCHAR2 | (14) | ||
SHARING | NUMBER | |||
ORIGIN_CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, CONSTRAINT_NAME
, CONSTRAINT_TYPE
, TABLE_NAME
, OBJECT_ID
, OBJECT_TYPE#
, SEARCH_CONDITION
, SEARCH_CONDITION_VC
, R_OWNER
, R_CONSTRAINT_NAME
, DELETE_RULE
, STATUS
, DEFERRABLE
, DEFERRED
, VALIDATED
, GENERATED
, BAD
, RELY
, LAST_CHANGE
, INDEX_OWNER
, INDEX_NAME
, INVALID
, VIEW_RELATED
, SHARING
, ORIGIN_CON_ID
FROM SYS.INT$DBA_CONSTRAINTS;
|
|
|