CreateTable demo

← List all

← Parse another

Parsing "Create table XTL_RBA_TEST (..."

Input

Original

Create table XTL_RBA_TEST (
    ID                             INTEGER             NOT NULL    
	generated by default as identity (start with 1  increment by 1  cache 20),
    DB_CHANGE_ID                   VARCHAR(255)                    ,
    STATUS                         VARCHAR(4)          NOT NULL  With Default 'N'  ,
    CHANGE_TYPE                    VARCHAR(4)          NOT NULL  With Default 'P'  ,
    CREATED_AT                     TIMESTAMP           NOT NULL    ,
    UPDATED_AT                     TIMESTAMP           NOT NULL    ,
    VALIDATION_STATUS              INTEGER                       With Default 0  ,
    VERSION_DEVELOPMENT            VARCHAR(255)                  With Default ''  ,
    VERSION_QUALITY                VARCHAR(255)                  With Default ''  ,
    VERSION_PRODUCTION             VARCHAR(255)                  With Default ''  ,
    DESCRIPTION                    CLOB(1048576)                   ,
    REMARKS                        CLOB(1048576)                   ,
    FOREIGN_REF_TYPE               VARCHAR(5)                      ,
    FOREIGN_REF                    VARCHAR(1000)                   ,
    DESCRIPTION_STATUS             VARCHAR(1)                      ,
    REVIEWER_ID                    INTEGER                         ,
    RESPONSIBLE_ID                 INTEGER                         ,
    CREATED_BY_ID                  INTEGER                         ,
    ASSIGNED_TO_ID                 INTEGER                         ,
    REQUIRED_PROMOTE_METHOD        VARCHAR(1)                      ,
    IGNORE_VERSION_DEVELOPMENT     INTEGER                         ,
    IGNORE_VERSION_QUALITY         INTEGER                         ,
    IGNORE_VERSION_PRODUCTION      INTEGER                         ) 
in USERSPACE1   ;

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

name data_type allow_null default primary_key unique autoincrement charset collate
ID INTEGER false as identity (start with 1 increment by 1 cache 20) false false false
DB_CHANGE_ID CHARACTER VARYING(255) true false false false
STATUS CHARACTER VARYING(4) false N false false false
CHANGE_TYPE CHARACTER VARYING(4) false P false false false
CREATED_AT TIMESTAMP false false false false
UPDATED_AT TIMESTAMP false false false false
VALIDATION_STATUS INTEGER WITH true 0 false false false
VERSION_DEVELOPMENT CHARACTER VARYING(255) true ' false false false
VERSION_QUALITY CHARACTER VARYING(255) true ' false false false
VERSION_PRODUCTION CHARACTER VARYING(255) true ' false false false
DESCRIPTION CLOB(1048576) true false false false
REMARKS CLOB(1048576) true false false false
FOREIGN_REF_TYPE CHARACTER VARYING(5) true false false false
FOREIGN_REF CHARACTER VARYING(1000) true false false false
DESCRIPTION_STATUS CHARACTER VARYING(1) true false false false
REVIEWER_ID INTEGER true false false false
RESPONSIBLE_ID INTEGER true false false false
CREATED_BY_ID INTEGER true false false false
ASSIGNED_TO_ID INTEGER true false false false
REQUIRED_PROMOTE_METHOD CHARACTER VARYING(1) true false false false
IGNORE_VERSION_DEVELOPMENT INTEGER true false false false
IGNORE_VERSION_QUALITY INTEGER true false false false
IGNORE_VERSION_PRODUCTION INTEGER true false false false

Cross-platform SQL

MySQL
CREATE TABLE XTL_RBA_TEST ( `ID` INTEGER            , DB_CHANGE_ID CHARACTER VARYING(255), STATUS CHARACTER VARYING(4), CHANGE_TYPE CHARACTER VARYING(4), CREATED_AT TIMESTAMP          , UPDATED_AT TIMESTAMP          , VALIDATION_STATUS INTEGER                       WITH, VERSION_DEVELOPMENT CHARACTER VARYING(255), VERSION_QUALITY CHARACTER VARYING(255), VERSION_PRODUCTION CHARACTER VARYING(255), DESCRIPTION CLOB(1048576), REMARKS CLOB(1048576), FOREIGN_REF_TYPE CHARACTER VARYING(5), FOREIGN_REF CHARACTER VARYING(1000), DESCRIPTION_STATUS CHARACTER VARYING(1), REVIEWER_ID INTEGER, RESPONSIBLE_ID INTEGER, CREATED_BY_ID INTEGER, ASSIGNED_TO_ID INTEGER, REQUIRED_PROMOTE_METHOD CHARACTER VARYING(1), IGNORE_VERSION_DEVELOPMENT INTEGER, IGNORE_VERSION_QUALITY INTEGER, IGNORE_VERSION_PRODUCTION INTEGER )
PostgreSQL
CREATE TABLE XTL_RBA_TEST ( "ID" INTEGER            , DB_CHANGE_ID CHARACTER VARYING(255), STATUS CHARACTER VARYING(4), CHANGE_TYPE CHARACTER VARYING(4), CREATED_AT TIMESTAMP          , UPDATED_AT TIMESTAMP          , VALIDATION_STATUS INTEGER                       WITH, VERSION_DEVELOPMENT CHARACTER VARYING(255), VERSION_QUALITY CHARACTER VARYING(255), VERSION_PRODUCTION CHARACTER VARYING(255), DESCRIPTION CLOB(1048576), REMARKS CLOB(1048576), FOREIGN_REF_TYPE CHARACTER VARYING(5), FOREIGN_REF CHARACTER VARYING(1000), DESCRIPTION_STATUS CHARACTER VARYING(1), REVIEWER_ID INTEGER, RESPONSIBLE_ID INTEGER, CREATED_BY_ID INTEGER, ASSIGNED_TO_ID INTEGER, REQUIRED_PROMOTE_METHOD CHARACTER VARYING(1), IGNORE_VERSION_DEVELOPMENT INTEGER, IGNORE_VERSION_QUALITY INTEGER, IGNORE_VERSION_PRODUCTION INTEGER )
Sqlite3
CREATE TABLE XTL_RBA_TEST ( "ID" INTEGER            , DB_CHANGE_ID CHARACTER VARYING(255), STATUS CHARACTER VARYING(4), CHANGE_TYPE CHARACTER VARYING(4), CREATED_AT TIMESTAMP          , UPDATED_AT TIMESTAMP          , VALIDATION_STATUS INTEGER                       WITH, VERSION_DEVELOPMENT CHARACTER VARYING(255), VERSION_QUALITY CHARACTER VARYING(255), VERSION_PRODUCTION CHARACTER VARYING(255), DESCRIPTION CLOB(1048576), REMARKS CLOB(1048576), FOREIGN_REF_TYPE CHARACTER VARYING(5), FOREIGN_REF CHARACTER VARYING(1000), DESCRIPTION_STATUS CHARACTER VARYING(1), REVIEWER_ID INTEGER, RESPONSIBLE_ID INTEGER, CREATED_BY_ID INTEGER, ASSIGNED_TO_ID INTEGER, REQUIRED_PROMOTE_METHOD CHARACTER VARYING(1), IGNORE_VERSION_DEVELOPMENT INTEGER, IGNORE_VERSION_QUALITY INTEGER, IGNORE_VERSION_PRODUCTION INTEGER )

Errata

comments powered by Disqus

© 2017 Brighter Planet, Inc.