Getting Started With VoltDB

contents

3.2. Defining the Database Schema

The VoltDB database schema is defined using standard SQL. For our sample, we create a schema including one table with three fields. Open your text editor and create the file helloworld.sql including the following code:

CREATE TABLE HELLOWORLD (
   HELLO VARCHAR(15),
   WORLD VARCHAR(15),
   DIALECT VARCHAR(15) NOT NULL,
   PRIMARY KEY (DIALECT)
);
contents