CreateTable demo

← List all

← Parse another

Parsing "CREATE TABLE foo ( \"id\" SER..."

Input

Original

CREATE TABLE foo ( "id" SERIAL PRIMARY KEY )

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: 1

name data_type allow_null default primary_key unique autoincrement charset collate
id INTEGER false true true true

Cross-platform SQL

MySQL
CREATE TABLE foo ( `id` INTEGER PRIMARY KEY AUTO_INCREMENT )
PostgreSQL
CREATE TABLE foo ( "id" SERIAL PRIMARY KEY )
Sqlite3
CREATE TABLE foo ( "id" INTEGER PRIMARY KEY AUTOINCREMENT )

Errata

comments powered by Disqus

© 2017 Brighter Planet, Inc.