Converting Your Database Structure to SQream
The following types are supported:
- tinyint - 1 byte
0 through 255
- smallint - 2 bytes
-32,768 through 32,767
- int - 4 bytes
-2,147,483,648 through 2,147,483,647
This is the recommended type for whole numbers.
- bigint - 8 bytes
-9,223,372,036,854,775,808 through 9,223,372,036,854,775,807
- real - Single precision floating point number
- float - Double precision floating point number
- varchar(n) - String representation for ascii characters.
n is a value between 1 and 2048.
- nvarchar(n) - String representation supporting multi-language characters. n is a value between 1 and 8000.
Date format, including year, month and day.
Timestamp format, including year, month and day, and time of day.
Format: ISO8601 (yyyy-MM-dd hh:mm:ss.SSS)
Example DDL, for a simple table:
CREATE TABLE foo
x int not null,
y date not null,
ts datetime not null,
ratio real default 1.0 not null,
comment varchar(32) null
See Best Practices to apply when designing a new table
If you have any question how to convert your DDL please contact SQream support