A.26 USER_TAB_COLUMNS
USER_TAB_COLUMNS
data dictionary for Oracle Database Gateway for DRDA.
The USER_TAB_COLUMNS
view contains columns of the tables, views, and clusters owned by the user.
Column name | Description |
---|---|
|
Name of the table, view, or cluster |
|
Name of the column |
|
Data type of 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 a decimal point in a number |
|
Whether the column permits nulls. Value is n if there is a NOT NULL constraint on the column or if the column is part of a PRIMARY key. |
|
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) |
|
Length of the column in characters |
|
N/A |
Parent topic: Oracle DB2 Data Dictionary Views