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 
    Date format, including year, month and day.
    Format: yyyy-MM-dd
  • datetime
    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 

  • 10
  • 17-May-2017
  • 415 Views