row-restrictions.md
ROW columns have several restrictions:
- Maximum nesting depth is 100.
- Vertica tables support up to 9800 columns and fields. The ROW itself is not counted, only its fields.
- ROW columns cannot use any constraints (such as NOT NULL) or defaults.
- ROW fields cannot be auto_increment or setof.
- ROW definition must include at least one field.
Row
is a reserved keyword within a ROW definition, but is permitted as the name of a table or column.- Tables containing ROW columns cannot also contain IDENTITY, default, SET USING, or named sequence columns.