CreateTable demo

← List all

← Parse another

Parsing " CREATE TABLE employees\r\n (..."

Input

Original

 CREATE TABLE employees
 (employeeid INTEGER NOT NULL,
 lastname VARCHAR(25) NOT NULL,
 firstname VARCHAR(25) NOT NULL,
 reportsto INTEGER NULL); 

Results

  1. Table structure
  2. Cross-platform SQL
  3. Errata

CreateTable is still young—please comment on any errors or surprises in the Errata section! Thank you.

Table structure

Number of columns: 4

name data_type allow_null default primary_key unique autoincrement charset collate
employeeid INTEGER false false false false
lastname CHARACTER VARYING(25) false false false false
firstname CHARACTER VARYING(25) false false false false
reportsto INTEGER true false false false

Cross-platform SQL

MySQL
CREATE TABLE employees ( employeeid INTEGER, lastname CHARACTER VARYING(25), firstname CHARACTER VARYING(25), reportsto INTEGER )
PostgreSQL
CREATE TABLE employees ( employeeid INTEGER, lastname CHARACTER VARYING(25), firstname CHARACTER VARYING(25), reportsto INTEGER )
Sqlite3
CREATE TABLE employees ( employeeid INTEGER, lastname CHARACTER VARYING(25), firstname CHARACTER VARYING(25), reportsto INTEGER )

Errata

comments powered by Disqus

© 2017 Brighter Planet, Inc.