ALL_TAB_COLUMNS

Previous Next JavaScript must be enabled to correctly display this content

C.14 ALL_TAB_COLUMNS

ALL_TAB_COLUMNS data dictionary for Oracle Database Gateway for Sybase.

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`VARCHAR2(30)`	-
`DATA_TYPE`	`VARCHAR2(8)`	-
`DATA_TYPE_MOD`	`VARCHAR2(1)`	`NULL`
`DATA_TYPE_OWNER`	`VARCHAR2(1)`	`NULL`
`DATA_LENGTH`	`NUMBER`	-
`DATA_PRECISION`	`NUMBER`	-
`DATA_SCALE`	`NUMBER`	-
`NULLABLE`	`VARCHAR2(1)`	"`Y`" or "`N`"
`COLUMN_ID`	`NUMBER`	-
`DEFAULT_LENGTH`	`NUMBER`	`0`
`DATA_DEFAULT`	`VARCHAR2(1)`	`NULL`
`NUM_DISTINCT`	`NUMBER`	`0`
`LOW_VALUE`	`NUMBER`	`0`
`HIGH_VALUE`	`NUMBER`	`0`
`DENSITY`	`NUMBER`	`0`
`NUM_NULLS`	`NUMBER`	`0`
`NUM_BUCKETS`	`NUMBER`	`0`
`LAST_ANALYZED`	`DATE`	`NULL`
`SAMPLE_SIZE`	`NUMBER`	`0`
`CHARACTER_SET_NAME`	`VARCHAR2(1)`	`NULL`
`CHAR_COL_DECL_LENGTH`	`NUMBER`	`0`
`GLOBAL_STATS`	`VARCHAR2(1)`	`NULL`
`USER_STATS`	`VARCHAR2(1)`	`NULL`
`AVG_COL_LEN`	`NUMBER`	`0`

Parent topic: Data Dictionary