Creating Arrays

Go Up to Using Arrays

Arrays are defined with the CREATE DOMAIN or CREATE TABLE statements. Defining an array column is just like defining any other column, except that you must also specify the array dimensions.

Array indexes range from –2³¹ to +2³¹–1.

The following statement defines a regular character column and a single-dimension, character array column containing four elements:

EXEC SQL
CREATE TABLE TABLE1
(
NAME CHAR(10),
CHAR_ARR CHAR(10)[4]
);

Array dimensions are always enclosed in square brackets following a data type specification of a column.

For a complete discussion of CREATE TABLE and array syntax, see Language Reference Guide.

Topics

Advance To:

Creating Multi-dimensional Arrays