Create Table

CREATE TABLE

    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

For tables with unknown columns skip column definition part:

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

Columns data types

You can define data types for each column.

Also you can use columns without [data types](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")');
    var res = alasql('SELECT * FROM sqlite_sequence');

returns:

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