Icon Introduction

ElevateDB supports most standard SQL types, which are organized by the following categories:

Exact Numeric Types
Approximate Numeric Types
String Types
Binary Types
Date and Time Types
Interval Types
Boolean Types

SQL 2003 Standard Deviations
The following areas are where ElevateDB deviates from the SQL 2003 standard:

DeviationDetails
Collection/Array TypesElevateDB does not support the creation or use of collection types, and only supports the use of array types in SQL/PSM routines.
RowTypesElevateDB does not support the creation or use of row types.
User-Defined TypesElevateDB does not support the creation or use of user-defined types.
Reference TypesElevateDB does not support the creation or use of reference types.
LocatorsElevateDB does not support the creation or use of locators for large object types.
Image