[Home] [Help]
[Dependency Information]
Object Name: | ALL_CONSTRAINTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Constraint definitions on accessible tables
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Owner of the table | |
CONSTRAINT_NAME | VARCHAR2 | (128) | Yes | Name associated with constraint definition |
CONSTRAINT_TYPE | VARCHAR2 | (1) | Type of constraint definition | |
TABLE_NAME | VARCHAR2 | (128) | Yes | Name associated with table with constraint definition |
SEARCH_CONDITION | LONG | (0) | Text of search condition for table check | |
SEARCH_CONDITION_VC | VARCHAR2 | (4000) | Possibly truncated text of search condition for table check | |
R_OWNER | VARCHAR2 | (128) | Owner of table used in referential constraint | |
R_CONSTRAINT_NAME | VARCHAR2 | (128) | Name of unique constraint definition for referenced table | |
DELETE_RULE | VARCHAR2 | (9) | The delete rule for a referential constraint | |
STATUS | VARCHAR2 | (8) | Enforcement status of constraint - ENABLED or DISABLED | |
DEFERRABLE | VARCHAR2 | (14) | Is the constraint deferrable - DEFERRABLE or NOT DEFERRABLE | |
DEFERRED | VARCHAR2 | (9) | Is the constraint deferred by default - DEFERRED or IMMEDIATE | |
VALIDATED | VARCHAR2 | (13) | Was this constraint system validated? - VALIDATED or NOT VALIDATED | |
GENERATED | VARCHAR2 | (14) | Was the constraint name system generated? - GENERATED NAME or USER NAME | |
BAD | VARCHAR2 | (3) | Creating this constraint should give ORA-02436. Rewrite it before 2000 AD. | |
RELY | VARCHAR2 | (4) | If set, this flag will be used in optimizer | |
LAST_CHANGE | DATE | The date when this column was last enabled or disabled | ||
INDEX_OWNER | VARCHAR2 | (128) | The owner of the index used by this constraint | |
INDEX_NAME | VARCHAR2 | (128) | The index used by this constraint | |
INVALID | VARCHAR2 | (7) | ||
VIEW_RELATED | VARCHAR2 | (14) | ||
ORIGIN_CON_ID | NUMBER | ID of Container where row originates |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, CONSTRAINT_NAME
, CONSTRAINT_TYPE
, TABLE_NAME
, 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
, ORIGIN_CON_ID
FROM SYS.ALL_CONSTRAINTS;
|
|
|