row-restrictions.md

ROW columns have several restrictions:

  • The 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.

  • A 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.

  • ROW columns cannot be modified using ALTER TABLE...ALTER COLUMN.

  • Tables containing ROW columns cannot also contain identity, auto-increment, default, SET USING, or sequence columns.