Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > CREATE TABLE >

Range Definition

Use the range definition to specify the minimum and maximum values of the entire range.

Read syntax diagramSkip visual syntax diagramRange 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 ]