CREATE TABLE statements specify the data type for each column in the table they define. This section describes the data types SQL supports for table columns. All the data types can store null values. A null value indicates that the value is not known and is distinct from all non‑null values.

Syntax

char_data_type
  |exact_numeric_data_type
  |approx_numeric_data_type
  |date_time_data_type
  |bit_string_data_type
  |array_data_type 
  |vararray_data_type

Example

The following example illustrates the use of data types in a CREATE TABLE statement:

CREATE TABLE CUSTOMERS
   (CUST_NUM INTEGER NOT NULL,
     COMPANY VARCHAR (20) NOT NULL, 
    CUST_REP INTEGER,
CREDIT_LIMIT INTEGER,
 PRIMARY KEY (CUST_NUM));

The OpenEdge SQL data types are:

  • CHARACTER
  • EXACT NUMERIC
  • APPROXIMATE NUMERIC
  • DATE-TIME
  • BIT STRING
  • ARRAY

Each data type is described in the following sections.