DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_CONS_COLUMNS

Object Details
Object Name: ALL_CONS_COLUMNS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information about accessible columns in constraint definitions

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the constraint definition
CONSTRAINT_NAME VARCHAR2 (128) Yes Name associated with the constraint definition
TABLE_NAME VARCHAR2 (128) Yes Name associated with table with constraint definition
COLUMN_NAME VARCHAR2 (4000)
Name associated with column or attribute of object column specified in the constraint definition
POSITION NUMBER

Original position of column or attribute in definition
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      CONSTRAINT_NAME
,      TABLE_NAME
,      COLUMN_NAME
,      POSITION
FROM SYS.ALL_CONS_COLUMNS;

Dependencies

[top of page]

SYS.ALL_CONS_COLUMNS references the following:

SchemaSYS
TableATTRCOL$
TableCCOL$
TableCDEF$
TableCOL$
TableCON$
TableOBJAUTH$
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.ALL_CONS_COLUMNS is referenced by following:

SchemaPUBLIC
SynonymALL_CONS_COLUMNS
SchemaSYS
Package BodyDBMS_CUBE_ADVISE - show dependent code
Package BodyDMP_SEC - show dependent code