Table 9-6 shows the minimum and maximum values for expected row size and the meaning of the special values 0 and 1.
exp_row_size values |
Minimum, maximum, and special values |
---|---|
Minimum |
The greater of:
|
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.