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

VIEW: SYS.DBA_CONS_COLUMNS

Object Details
Object Name: DBA_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.DBA_CONS_COLUMNS;

Dependencies

[top of page]

SYS.DBA_CONS_COLUMNS references the following:

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

SchemaPUBLIC
SynonymDBA_CONS_COLUMNS
SchemaSYS
Package BodyDBMSOBJG - show dependent code
PL/SQL PackageDBMS_REDEFINITION_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_FLA - show dependent code
Package BodyDBMS_SWRF_INTERNAL - show dependent code