CREATE TABLE

Grammar Syntax

The CREATE TABLE syntax is a grammar that does not fit on just one page, but here is an overview. 

<table definition> ::=
  CREATE [ <table scope>  ] TABLE <table name>  <table contents source> 
      [ WITH <system versioning clause>  ]
      [ ON COMMIT <table commit action>  ROWS ]

Click here to go to the ANSI SQL Standard specification for this syntax.

Navigate to the following pages to get more details about the translation spec for CREATE TABLE syntax.

  1. Basic Table

  2. Table Scope

  3. On Commit

  4. With System Versioning

  5. Column Definition

  6. Table Contents Source

PreviousStatementsNextBasic Table

Last updated