SYS.COLUMNS
The COLUMNS
table describes every column in every table in the database, including the name of the column, the type of the column and whether the column is nullable.
Columns
Column name | Type | Description |
---|---|---|
|
|
Same as |
|
|
Ordinal number of the column as specified when the table is created or subsequently altered. See also |
|
|
Column name |
|
|
Column specification flags 0x01 - Column is in a primary key. 0x02 - Column value is varying-length ( 0x04 - Column value can be 0x08 - Column values are unique. |
|
|
Data type of column
|
|
|
Internal use |
|
|
Length of the column (maximum length for varying-length columns) |
|
|
Number of bytes a given column contributes to the inline width of a row |
|
|
User-defined identifier for column (set with |
|
|
The table partition that the column is in. The primary table partition has the value of 0. The See ALTER TABLE in Oracle TimesTen In-Memory Database SQL Reference or SYS.TABLES for more information. |
|
|
The default column value |
|
|
Semantics for the column ' '
|
|
|
Internal use |
|
|
For TimesTen Scaleout: If the column is in the primary partition of the table, the value is equal to the For TimesTen Classic: The value is equal to the For TimesTen Scaleout, the |