INSERT

The INSERT according to the grammar.

Grammar Syntax

<insert statement> ::=
  INSERT INTO <insertion target>  <insert columns and source> 
<insertion target> ::=
  <table name> 
<insert columns and source> ::=
    <from subquery> 
  | <from constructor> 
  | <from default> 
<from subquery> ::=
  [ <left paren>  <insert column list>  <right paren>  ]
      [ <override clause>  ]
      <query expression> 
<from constructor> ::=
  [ <left paren>  <insert column list>  <right paren>  ]
      [ <override clause>  ]
      <contextually typed table value constructor> 

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. FROM SUBQUERY

2. FROM CONSTRUCTOR

3. FROM DEFAULT