Default, minimum, and maximum values for exp_row_size

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

Table 9-6: Valid values for expected row size

exp_row_size values

Minimum, maximum, and special values

Minimum

The greater of:

  • 2 bytes

  • The sum of all fixed-length columns

Maximum

Maximum data row length

0

Use server-wide default value

1

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.