A.10 ALL_TAB_COLUMNS
ALL_TAB_COLUMNS
data dictionary for Oracle Database Gateway for DRDA.
The ALL_TAB_COLUMNS
view contains columns of all tables, views, and clusters accessible to the user.
Column name | Description |
---|---|
|
Owner of the table or view |
|
Table or view name |
|
Column name |
|
Data type of the column |
|
Data type modifier of the column |
|
Owner of the data type of the column |
|
Maximum length of the column in bytes |
|
N/A |
|
Digits to the right of decimal point in a number |
|
Whether the column permits nulls? Value is n if there is a |
|
Sequence number of the column as created |
|
N/A |
|
N/A |
|
Number of distinct values in each column of the table |
|
For tables with more than three rows, the second lowest and second highest values. These statistics are expressed in hexadecimal notation for the internal representation of the first 32 bytes of the values. |
|
N/A |
|
N/A |
|
Number of nulls in the column |
|
Number of buckets in histogram for the column |
|
Date on which this column was most recently analyzed |
|
Sample size used in analyzing this column |
|
Name of the character set |
|
Length of the character set |
|
N/A |
|
N/A |
|
Average length of the column (in bytes) |
|
Displays the length of the column in characters |
|
N/A |
Parent topic: Oracle DB2 Data Dictionary Views