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 INT$DBA_CONSTRAINTS
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 INT$DBA_CONSTRAINTS
|
|
|