Create Tables

LingoDB provides core functionality for creating tables

create table t(
    -- usual column definitions
    a string,
    b int primary key -- define primary key,
    c decimal(4,2),
    d float(2) not null,
    -- ...
    -- define primary key
    primary key(a)
)

Supported Types

Unsupported Features (incomplete list)

Statements like create table as are not supported

create table y as 
    select * 
    from z

unique constraint is not yet supported

create table t(
    a string unique --not supported
)