Columns
Use this page to view information about table columns.
The page displays the following information about the table columns:
- Type
- The data type for the column, such as CHAR or DECIMAL.
- Length
- The column length. The value and the units depend on the data type of the column. For example, for a VARCHAR column, the value (255,0) means that the maximum size is 255 bytes, and the minimum reserved space is 0 bytes. For a DATETIME column, the value might be YEAR to FRACTION(5).
- Extended Type
- The extended data type: LIST, MULTISET, SET, Named ROW, Unnamed ROW, BSON, JSON, or LONGVARCHAR data type.
- Allow Nulls
- An indicator whether the column allows null values.
- External Length
- For fixed-width external tables, the character length for the column in the external table.