[Home] [Help] [Dependency Information]

TABLE: MDSYS.MD$COL

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Unique Key: MD15

1. OWNER
2. MDTNAME
3. CNAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
MD15	NORMAL	UNIQUE	SYSTEM	OWNER MDTNAME CNAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
MD$COL		MD$TAB	MD$COL OWNER MD$COL MDTNAME
MD$DIM		MD$COL	MD$DIM OWNER MD$DIM MDTNAME MD$DIM CNAME

Columns

Query Text

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

SELECT OWNER
,      MDTNAME
,      CNAME
,      PK
,      NDIM
,      MXL
FROM MDSYS.MD$COL;

Dependencies

[top of page]

MDSYS.MD$COL does not reference any database object

MDSYS.MD$COL is referenced by following:

MDSYS

ALL_MD_COLUMNS

DBA_MD_COLUMNS

USER_MD_COLUMNS