Constraints starting with SYS are not visible.

[jrow]

When I display a table's constraints the constraints starting with SYS are not visible. Is this a feature that I can turn off?

Thanks - JR

SQL> select * from user_constraints where table_name = 'ADJUSTMENT_TYPE';

OWNER CONSTRAINT_NAME CONSTRAINT_TYPE TABLE_NAME SEARCH_CONDITION R_OWNER R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHANGE INDEX_OWNER INDEX_NAME INVALID VIEW_RELATED
------------------------------ ------------------------------ --------------- ------------------------------ -------------------------------------------------------------------------------- ------------------------------ ------------------------------ ----------- -------- -------------- --------- ------------- -------------- --- ---- ------------------- ------------------------------ ------------------------------ ------- --------------
NEXTFARE_MAIN SYS_C006913 C ADJUSTMENT_TYPE "ADJUSTMENT_TYPE_ID" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME 02/11/2009 10:31:35
NEXTFARE_MAIN SYS_C006914 C ADJUSTMENT_TYPE "SHORT_DESC" IS NOT NULL ENABLED NOT DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME 02/11/2009 10:31:35
NEXTFARE_MAIN PK_ADJUSTMENT_TYPE P ADJUSTMENT_TYPE ENABLED NOT DEFERRABLE IMMEDIATE NOT VALIDATED USER NAME 02/11/2009 10:31:35 NEXTFARE_MAIN PK_ADJUSTMENT_TYPE

Executed in 0.156 seconds

 

[Marco Kalter]

These are inline constraints, which are visible as a "not null" property.