Default, minimum, and maximum values for exp_row_size

Table 14-6 shows the minimum and maximum values for expected row size and the meaning of the special values 0 and 1.

Table 14-6: Valid values for expected row size

exp_row_size values

Minimum, maximum, and special values


The greater of:

  • 2 bytes

  • The sum of all fixed-length columns


Maximum data row length


Use server-wide default value


Fully pack all pages; do not reserve room for expanding rows

You cannot specify an expected row size for tables that have fixed-length columns only. Columns that accept null values are by definition variable-length, since they are zero-length when null.