Data types and constraints

Data types and constraints are used to define table columns when creating tables via SQL.

NOTE: For ease of use, Constraint information is included with the relevant Data type reference.

Before you begin

• Create a Cloud database using the UI, OR
• Create a Cloud database using the API

Data types

Data types used to define the type of data that a table column can contain. They are modified by Constraints.

Mapping data types

Numeric data types

• BOOL
• DECIMAL
• ID
• INT

String data types

• STRING

Date/Time data types

• TIMESTAMP

FeatureBase data types

• IDSET
• STRINGSET

Constraints

Constraints are applied to data types to modify and optimize how table data is stored and accessed.

Constraints are applied when a column is created.

Further information

• Create a Cloud table
• Create a Cloud table using the API