SonicBase. In-memory embedded or distributed streaming sql database

SQL Create Table Statement

Creates a table to store records in.


CREATE TABLE table_name (column type [,column type...] [PRIMARY KEY (key_column [,key_column...])
table_name:  name of the table to create
column:   name of the column to create
key_column: name of the column to include in the primary key


create table persons (name VARCHAR, age INT, ssn VARCHAR, PRIMARY_KEY(ssn))