Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## Data types

> `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.

> This is the syntax for a data type:

> Syntax
>     char_data_type | exact_numeric_data_type | approx_numeric_data_type
>      | date_time_data_type | bit_string_data_type | vararray_data_type

> Example 1 illustrates the use of data types in a `CREATE TABLE` statement:

> Example 1: Data types in 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.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095