Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_CONS_COLUMNS Information about accessible columns in constraint definitions

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)NOwner of the constraint definition
2CONSTRAINT_NAMEVARCHAR230(null)NName associated with the constraint definition
3TABLE_NAMEVARCHAR230(null)NName associated with table with constraint definition
4COLUMN_NAMEVARCHAR24000(null)YName associated with column or attribute of object column specified in the constraint definition
5POSITIONNUMBER22(null)YOriginal position of column or attribute in definition

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:24
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here