Use the range definition to specify the minimum and maximum values of the entire range.
Range Definition: |--+--------------+--+-----+--max_val---------------------------| '-MIN--min_val-' '-MAX-'
Element | Description | Restrictions | Syntax |
---|---|---|---|
max_val | Maximum value in the range | Must be an INT or SMALLINT greater than or equal to min_val, if min_val is supplied | Literal Number,
p. Literal Number |
min_val | Minimum value in the range; the default is 0. | Must be an INT or SMALLINT less than or equal to max_val | Literal Number,
p. Literal Number |
You do not need to specify a minimum value. The minimum and maximum values define the exact range of values to allocate for each storage space.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]