Default value

If you do not specify an expected row size or a value of 0 when you create a data-only-locked table with variable-length columns, Adaptive Server uses the amount of space specified by the configuration parameter default exp_row_size percent for any table that has variable-length columns.

See “Setting a default expected row size server-wide” for information on how this parameter affects space on data pages. Use sp_help to see the defined length of the columns in the table.