ALL_TAB_COLUMNS

Previous Next JavaScript must be enabled to correctly display this content

C.11 ALL_TAB_COLUMNS

ALL_TAB_COLUMNS data dictionary for Oracle Database Gateway for SQL Server.

Name	Type	Value
`OWNER`	`VARCHAR2(256)`	-
`TABLE_NAME`	`VARCHAR2(256)`	-
`COLUMN_NAME`	`VARCHAR2(256)`	-
`DATA_TYPE`	`VARCHAR2(9)`	-
`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(5)`	-
`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_DEC_LENGTH`	`NUMBER`	`0`
`GLOBAL_STATS`	`VARCHAR2(1)`	`NULL`
`USER_STATS`	`VARCHAR2(1)`	`NULL`
`AVG_COL_LEN`	`NUMBER`	`0`
`CHAR_LENGTH`	`NUMBER`	-
`CHAR_USED`	`VARCHAR2(1)`	-
`V80_FMT_IMAGE`	`VARCHAR2(1)`	-
`DATA_UPGRADED`	`VARCHAR2(1)`	-
`HISTOGRAM`	`VARCHAR2(1)`	-

Parent topic: Data Dictionary