KeywordCREATE TABLE

CREATETABLEtableid;CREATETABLEtableid (        column type constraints, ...    );

alasql('CREATE TABLE star (  \                one INT DEFAULT 100, \                two STRING,\                three BOOL PRIMARY KEY); \    ');alasql('CREATE TABLE flight (flightNo INT, fromCity STRING, toCity STRING)');

Tables without column declarations

alasql('CREATE TABLE one');alasql('INSERT INTO one VALUES {a:1}');

Columns data types

alasql('CREATE DATABASE test252; USE test252;');alasql('CREATE TABLE sqlite_sequence(name,seq)');alasql('INSERT INTO sqlite_sequence VALUES (1,10)');alasql('INSERT INTO sqlite_sequence VALUES ("one","ten")');varres=alasql('SELECT * FROM sqlite_sequence');

    [ {"name":1,"seq":10 }, {"name":"one","seq":"ten" } ]

Constraints